On 1/1/19 12:05 PM, David G. Johnston wrote:
On Tuesday, January 1, 2019, Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxx
