On Tuesday, January 1, 2019, Adrian Klaver <adrian.kla...@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. David J.
