Re: Get sum of sums
| От | Victor Yegorov |
|---|---|
| Тема | Re: Get sum of sums |
| Дата | |
| Msg-id | CAGnEbojZ=BjoSma+xG43qR6FmeSF+T-c7z4qt8CCh+LjVFu+9w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Get sum of sums (Steve Clark <sclark@netwolves.com>) |
| Ответы |
Re: Get sum of sums
|
| Список | pgsql-general |
2016-05-03 22:48 GMT+03:00 Steve Clark <sclark@netwolves.com>:
select ip_dst as "Receiver" ,sum(bytes) as "RX Bytes" from acct_v9 where stamp_inserted >= '2016-04-26' and stamp_inserted <= '2016-04-30' and tag=246 group by ip_dst order by "RX Bytes" desc limit 10;
SELECT ip_dst AS "Receiver",
sum(bytes) AS "RX Bytes",
sum(sum(bytes)) OVER () AS "Grand Total"
FROM acct_v9
WHERE stamp_inserted BETWEEN '2016-04-26' AND '2016-04-30'
AND tag=246
GROUP BY ip_dst
ORDER BY "RX Bytes" DESC
LIMIT 10;
I am not sure bout the LIMIT though, I hope window function will be calculated after the LIMIT is applied.
--
Victor Y. Yegorov
В списке pgsql-general по дате отправления: