P Kishor wrote: > > > sqlite> select t.* from test t join (select name, max(weight) as m > from test group by name) w on t.weight = w.m and t.name = w.name; > To me the following almost identical query is more readable, but I guess it is objectively better only if you are having trouble with the Period key of your keyboard:
select * from test join (select name as n, max(weight) as m from test group by name) where name = n and weight = m; Gerry _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users