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

Reply via email to