On 10 May 2010, at 12:20pm, Simon Slavin wrote: > Sort in descending order of rank, and add LIMIT 10 to the end of your SELECT > statement. Depending on your names, it'll look something like > > SELECT * FROM dailyRankingTable ORDER BY rank DESC LIMIT 10
Hahaha. Wrong way up. That should be either 'ORDER BY rank' without the 'DESC' or 'ORDER BY points DESC'. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
