Re: A join of 2 tables with sum(column) > 30

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: A join of 2 tables with sum(column) > 30
Дата
Msg-id AANLkTi=sc+haUjchgHG7qnBvU3tF1uhVXYPgZWSdcp0n@mail.gmail.com
обсуждение исходный текст
Ответ на Re: A join of 2 tables with sum(column) > 30  ("Igor Neyman" <ineyman@perceptron.com>)
Список 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 по дате отправления:

Предыдущее
От: "MauMau"
Дата:
Сообщение: Is PostgreSQL supported on RHEL6?
Следующее
От: Guillaume Yziquel
Дата:
Сообщение: Startup messages for socket protocol