Re: Selecting All Columns Associated With Maximum Value of One Column

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Selecting All Columns Associated With Maximum Value of One Column
Date: 2011-10-06 13:13:52
Message-ID: alpine.LNX.2.00.1110060612190.26051@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2011-10-06 13:34:00 Re: Selecting All Columns Associated With Maximum Value of One Column
Previous Message Rich Shepard 2011-10-06 13:11:27 Re: Selecting All Columns Associated With Maximum Value of One Column