I still sqlite 2.8.17. Can someone help me to convert this sql? tx
select f.type, f.variety, f.price from fruits f where rowid in (select rowid from fruits where type = f.type order by price desc limit 1) order by f.type asc, f.price desc; _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users