ТавроФорум - Показать сообщение отдельно - Вапрос про SQL-запрос

**kkk** · 22.06.2009, 14:13

Вот запрос, который пока есть, без разбивки по ФИО

SELECT
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.01.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.01.2008')) AS January,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.02.2008') AND (date_trunc('day', "OrderCreationTime") <= '28.02.2008')) AS February,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.03.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.03.2008')) AS March,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.04.2008') AND (date_trunc('day', "OrderCreationTime") <= '30.04.2008')) AS April,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.05.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.05.2008')) AS May,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.06.2008') AND (date_trunc('day', "OrderCreationTime") <= '30.06.2008')) AS June,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.07.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.07.2008')) AS July,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.08.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.08.2008')) AS August,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.09.2008') AND (date_trunc('day', "OrderCreationTime") <= '30.09.2008')) AS September,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.10.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.10.2008')) AS October,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.11.2008') AND (date_trunc('day', "OrderCreationTime") <= '30.11.2008')) AS November,
(SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.12.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.12.2008')) AS December

22.06.2009, 14:13	#4
kkk Кулверстукас ♂ Адрес: Киев, Воскресенка Возраст: 45 Сообщений: 16,076 Машина: Dana 1.2HTP Ambition Длина: 473040мкм Диаметр: 64мм	Re: Re: Вапрос про SQL-запрос Вот запрос, который пока есть, без разбивки по ФИО SELECT (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.01.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.01.2008')) AS January, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.02.2008') AND (date_trunc('day', "OrderCreationTime") <= '28.02.2008')) AS February, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.03.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.03.2008')) AS March, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.04.2008') AND (date_trunc('day', "OrderCreationTime") <= '30.04.2008')) AS April, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.05.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.05.2008')) AS May, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.06.2008') AND (date_trunc('day', "OrderCreationTime") <= '30.06.2008')) AS June, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.07.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.07.2008')) AS July, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.08.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.08.2008')) AS August, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.09.2008') AND (date_trunc('day', "OrderCreationTime") <= '30.09.2008')) AS September, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.10.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.10.2008')) AS October, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.11.2008') AND (date_trunc('day', "OrderCreationTime") <= '30.11.2008')) AS November, (SELECT sum("OrderCost") from ordertable WHERE (date_trunc('day', "OrderCreationTime") >= '01.12.2008') AND (date_trunc('day', "OrderCreationTime") <= '31.12.2008')) AS December __________________ Не думай о людишках свысока.