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 по дате отправления: