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

Reply via email to