Thanks, Igor. That worked perfectly. Time for me to read up on rowid and the subtleties of subselects.
Regards, - Robert On Thu, Jan 8, 2009 at 6:48 AM, Igor Tandetnik <itandet...@mvps.org> wrote: > select div, team from teams t1 where rowid in > (select rowid from teams t2 where t1.div = t2.div > order by wins desc limit 3); _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users