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

From Alexander Farber
Subject Re: A join of 2 tables with sum(column) > 30
Date
Msg-id AANLkTi=sc+haUjchgHG7qnBvU3tF1uhVXYPgZWSdcp0n@mail.gmail.com
Whole thread Raw
In response to Re: A join of 2 tables with sum(column) > 30  ("Igor Neyman" <ineyman@perceptron.com>)
List pgsql-general
Thank you all for the replies -

On Wed, Mar 16, 2011 at 3:05 PM, Igor Neyman <ineyman@perceptron.com> wrote:
> 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.

I have already read many SQL-docs (really) and
I've done Perl, PHP, Java, C, ActionScript, etc. programming
at various points of time (for living AND/OR for fun)
and SQL is the most mind-boggling for me.

Regards
Alex

pgsql-general by date:

Previous
From: "MauMau"
Date:
Subject: Is PostgreSQL supported on RHEL6?
Next
From: Guillaume Yziquel
Date:
Subject: Startup messages for socket protocol