Re: Finding the max value in a SECOND column

From: <>
Date: Fri, 2 Jun 2017 06:29:28 -0700 (PDT)
Message-ID: <>

[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

Original text of this message