Get different sums from the same table in one query

From: Dani Castaños <danitao(dot)mailists(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Get different sums from the same table in one query
Date: 2007-10-08 10:49:04
Message-ID: 470A0B20.40203@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in,
sum(total_num_messages)
FROM statistics_daily
WHERE message_type_id IN (6)
AND statistics_date = CURRENT_DATE
AND telecom_operator_id <> 0
AND telephone_number IN ( $numbers )
GROUP BY date_in

SELECT TO_CHAR( statistics_date, 'DD/MM/YYYY') AS date_in,
sum(total_num_messages)
FROM statistics_daily
WHERE message_type_id IN (21)
AND statistics_date = CURRENT_DATE
AND telecom_operator_id <> 0
AND telephone_number IN ( $numbers )
GROUP BY date_in

Thank you in advance!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2007-10-08 10:54:22 Re: Get different sums from the same table in one query
Previous Message Rodrigo De León 2007-10-07 19:16:16 Re: SQL query question