Re: Get different sums from the same table in one query - Mailing list pgsql-sql

Dani Castaños wrote:
> Hi all!
>
> I want to put this three queries in only one... Take a look that the
> only thing that changes is the message_type_id. Any suggestions??
>
>         SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in,
> sum(total_num_messages)
>         FROM statistics_daily
>         WHERE message_type_id IN (4,5)
>         AND statistics_date = CURRENT_DATE
>         AND telecom_operator_id <> 0
>         AND telephone_number IN ( $numbers )
>         GROUP BY date_in

Is this what you mean?

SELECT message_type_id, to_char...
...
WHERE message_type_id IN (4,5,6,21)
...
GROUP BY message_type_id, date_id



--   Richard Huxton  Archonet Ltd