Re: Finding the max value in a SECOND column
From: <bit-naughty_at_hotmail.com>
Date: Fri, 2 Jun 2017 06:29:28 -0700 (PDT)
Message-ID: <bf9b3fb9-375d-49e5-9589-232b497c2e54_at_googlegroups.com>
Date: Fri, 2 Jun 2017 06:29:28 -0700 (PDT)
Message-ID: <bf9b3fb9-375d-49e5-9589-232b497c2e54_at_googlegroups.com>
[Quoted] [Quoted] 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?
[Quoted] What would the GROUP BY be for? Received on Fri Jun 02 2017 - 15:29:28 CEST