| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|Determine four highest numbers from DB|
| 1:58 pm on Jun 2, 2004 (gmt 0)|
Got this interesting problem, I have a table and in there I have a field called itemid which is set to integer, and basically its a list of numbers.
The problem is, how do you go about calculating the 4 highest numbers?
I've tried using SQL command but I don't think I have the version which support sub selects
select * from t where number in (select max(number) from t)
Thanks in advance :o)
| 2:14 pm on Jun 2, 2004 (gmt 0)|
Under SQL Server or Access this would be:
Select Top 4 * From t Order By number Desc
I would try something similar in MySQL ... though not all DBMS' implement "Top".
| 2:17 pm on Jun 2, 2004 (gmt 0)|
well in mysql you could
SELECT number_feild FROM table ORDER DESC LIMIT 0,4
The limit starts the first record and returns the four values. If that does not work it is 4,0 :)
| 2:38 pm on Jun 2, 2004 (gmt 0)|
That works :o)
I've ammended the query just slightly because it didn't work first time round, I put the 'ORDER by itemid' in the query.
SELECT prop_date,heading FROM newsfeed ORDER by itemid DESC LIMIT 0,4;
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved