| Determine four highest numbers from DB
|
woldie
msg:1294108 | 1:58 pm on Jun 2, 2004 (gmt 0) |
Hi, 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)
|
dwilson
msg:1294109 | 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".
|
ukgimp
msg:1294110 | 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 :)
|
woldie
msg:1294111 | 2:38 pm on Jun 2, 2004 (gmt 0) |
Thanks UKGimp, 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; Thanks everyone.
|
|
|
