Re: A join of 2 tables with sum(column) > 30 - Mailing list pgsql-general

> -----Original Message-----
> From: Alexander Farber [mailto:alexander.farber@gmail.com]
> Sent: Tuesday, March 15, 2011 5:45 PM
> To: pgsql-general@postgresql.org
> Subject: Re: A join of 2 tables with sum(column) > 30
>
> And same for a simple select-query from1 table (w/o join):
>
> # select id from pref_match where sum(completed) > 30 group by id;
> ERROR:  aggregates not allowed in WHERE clause LINE 1: select
> id from pref_match where sum(completed) > 30 group by...
>                                         ^
>

You should "HAVING" close (not "WHERE") for an aggregate as a condition:

Select id, sum(col1) from tab
Where id > 10
Group by id
Having sum)col1) >30;

Spend some time reading basic SQL docs/books - it'll help you
tremendously.

Regards,
Igor Neyman