On Thu, 1 Dec 2016 11:12:48 -0800 James Walker <jam...@frameforge3d.com> wrote:
> SELECT MIN(PRICE), IDENT FROM INFO; > > and get what I want. But in SQLite 2 (legacy code), this doesn't > work... I get the minimum value, but NULL in the IDENT column. Does it work with both versions if you write it correctly? SELECT MIN(PRICE), IDENT FROM INFO GROUP BY IDENT; > I want to find the IDENT of the row with the minimum value of PRICE That's what quantification was invented for select * from info where price in ( SELECT MIN(PRICE) FROM INFO ); --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users