Get different sums from the same table in one query
| От | Dani Castaños | 
|---|---|
| Тема | Get different sums from the same table in one query | 
| Дата | |
| Msg-id | 470A0B20.40203@gmail.com обсуждение исходный текст | 
| Ответы | Re: Get different sums from the same table in one query Re: Get different sums from the same table in one query | 
| Список | 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!
		
	В списке pgsql-sql по дате отправления: