Re: Query help

On 1/1/19 12:05 PM, David G. Johnston wrote:
> On Tuesday, January 1, 2019, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com