On Thu, 1 Dec 2016 11:12:48 -0800
James Walker 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?
On 12/1/2016 11:55 AM, Baruch Burstein wrote:
On Thu, Dec 1, 2016 at 9:12 PM, James Walker
wrote:
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;
a
On Thu, Dec 1, 2016 at 1:12 PM, James Walker
wrote:
> 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
On Thu, Dec 1, 2016 at 9:12 PM, James Walker
wrote:
> 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
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, b
5 matches
Mail list logo