Re: Query help
| От | David G. Johnston |
|---|---|
| Тема | Re: Query help |
| Дата | |
| Msg-id | CAKFQuwZ=YT0AaNR94er-LmVb_4Oj0q_KyX=eUsD7usWEAg00SQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Query help (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Query help
|
| Список | pgsql-general |
On Tuesday, January 1, 2019, Adrian Klaver <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.
David J.
В списке pgsql-general по дате отправления: