Re: Finding the max value in a SECOND column

From: Axel Schwenke <axel.schwenke_at_gmx.de>
Date: Thu, 1 Jun 2017 21:44:04 +0200
Message-ID: <ogpqji$a8q$1_at_dont-email.me>


On 01.06.2017 18:25, bit-naughty_at_hotmail.com wrote:
> If I have a table which has 2 (amongst others) fields, one of which will
> go up 1,2, so on,.... and WITHIN that the 2nd field will go up like, the first
> row will be 1,1 the 2nd (not necessarily after that in the table) 1,2...
and so on.
> How do I get the line that will be the LAST VALUE in the sequence for a
particular
> number - say for "1" above, the last row in the 2nd field will be "2" in this case
> how do I get that row?

[Quoted] By using GROUP BY and the MAX() aggregate function. Buy a text book on SQL. Received on Thu Jun 01 2017 - 21:44:04 CEST

Original text of this message