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

On Thu, 6 Oct 2011, David Johnston wrote:

> Missing the FROM before chemistry

   D'oh! Obviously not yet sufficiently cafinated this morning.

>>  Also, with the window function can I limit the output to a single str_name
>> and param?
>
> Not directly.  After you create the windowed result you can turn it into a
> sub-query and filter that.  The other form suggested (where quant = select
> max(quant) from chemistry where ...) is probably a better performer though
> for your need - I did't read the subject line closely enough and my two
> options don't directly give you what you are looking for.  Though era ing
> the window query and then adding a (where quant_max = quant) clause would
> get you closer; quant_max being the column alias for the window
> expression.

   Ah.

Thanks, David,

Rich