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

On Wed, 5 Oct 2011, David Johnston wrote:

> "Max" is an aggregate function and thus requires one of:
> 1) GROUP BY
> 2) "Window" -  max(quant) OVER (PARTITION BY ...)
> To be present in the query.

David,

   I was unaware of the windows functions. I see the document page for 9.0.5
so I'll carefully read that and upgrade from 9.0.4 (which may also have this
function; I'll check).

Thanks,

Rich