On Thu, Dec 1, 2016 at 9:12 PM, James Walker <jam...@frameforge3d.com>
> Let's say I have a table INFO with columns PRICE and IDENT, and I want to
> find the IDENT of the row with the minimum value of PRICE. In SQLite 3, I
> can say
> 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. I could say
> SELECT PRICE, IDENT FROM INFO ORDER BY PRICE;
> and ignore all but the first row of the result, but I'm sure there must be
> a better way?
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
sqlite-users mailing list