Re: Selecting All Columns Associated With Maximum Value of One Column - Mailing list pgsql-general

On Wed, 5 Oct 2011, Chris Curvey wrote:

> Based on your subject line, I'm guessing that you want something like this:
>
> select quant, param, site_id, sample_date, str_name from chemistry where
> param = 'TDS' and str_name = 'BurrowCrk' and quant = (select max(quant)
> from chemistry where param = 'TDS' and str_name = 'BurrowCrk')

Chris,

   Thank you. I missed seeing the latter part.

   This returns 0 rows, but it puts me on the right track.

Rich