Re: Single Table Select With Aggregate Function

On Tue, 3 Jan 2012, Tom Lane wrote:

> You can do that type of thing using subqueries, eg
>
>     select ... from mytab
>       where col = (select max(col) from mytab where ...)

   Thanks, Tom. That's what I thought I needed.

> or if you don't mind a nonstandard construct, consider SELECT DISTINCT ON.
> There's an example of how to use that in the SELECT reference page
> (look for the weather-reports example).  In any case you're going to
> have to consider what you want to have happen when there are multiple
> occurrences of the maximum value.

   I'll look at that, too.

Much appreciated,

Rich