Re: Finding the max value in a SECOND column

On 6/2/2017 9:29 AM, bit-naughty_at_hotmail.com wrote:
> On Friday, June 2, 2017 at 1:14:07 AM UTC+5:30, Axel Schwenke wrote:
>
>> By using GROUP BY and the MAX() aggregate function. Buy a text book on SQL.
>
> Already have one. Can you be a bit clearer - how would I do the MAX on the SECOND col, for a particular value of the 1st?
> SELECT MAX(col2) FROM table WHERE col1=1 ? Something like that?
>

Did you try it?

> What would the GROUP BY be for?
>

If you're selecting multiple values for col1.

As Axel said - by a text book on SQL. These are very basic statements you shouldn't have to ask about.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex_at_attglobal.net
==================