Horton

Re: Query help

Adrian Klaver <adrian.klaver@aklaver.com>

View thread View on postgr.es
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: John W Higgins <wishdev@gmail.com>, pgsql-general <pgsql-general@postgresql.org>
Date: 2019-01-01T22:10:17Z
Lists: pgsql-general 
On 1/1/19 12:05 PM, David G. Johnston wrote:
> On Tuesday, January 1, 2019, Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 1/1/19 11:26 AM, John W Higgins wrote:
> 
>         with accounts_over_total as (
>         select accountid from transactions where sum(amount) >= 50 group
>         by accountid)
> 
> 
>     Unfortunately there is a hitch in the above:(
> 
>     select p_item_no from projection where sum(qty) > 100 group
>     by(p_item_no);
>     ERROR:  aggregate functions are not allowed in WHERE
> 
> 
> Which is where the HAVING clause comes in.  It filters out groups based 
> on an expression containing an aggregate function.

Hmm, guess I should spend more time reading the SELECT docs:)

> 
> David J.


-- 
Adrian Klaver
adrian.klaver@aklaver.com