Welcome to WebmasterWorld Guest from 220.127.116.11
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)