That gets me the best team in the first five divisions. I would like the top three teams within each division.
Regards, - Robert On Thu, Jan 8, 2009 at 12:19 AM, aditya siram <aditya.si...@gmail.com> wrote: > Hi Robert, > SQL has a LIMIT keyword. I have used it to take the top 'x' entries of a > large table , so for example: > SELECT * from table LIMIT 20 > > You should be able to use it in your query like so: > select div, team, max(wins) from teams group by div limit 5; _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
