pg按日,周,月进行数据统计

最新推荐文章于 2023-01-03 10:02:31 发布

weixin_34067980

最新推荐文章于 2023-01-03 10:02:31 发布

阅读量731

点赞数

文章标签：数据库前端 java ViewUI

原文链接：http://www.cnblogs.com/fxust/p/8384707.html

版权

pg数据库按周,月统计数据

SELECT date_trunc('WEEK', insert_time) as insertDate, SUM(data_increment) as dataTotal,SUM(human_increment) as humanTotal  from human_data_sum t where t.idtype=? GROUP BY insertDate ORDER BY insertDate DESC

SELECT date_trunc('MONTH', insert_time) as insertDate, SUM(data_increment) as dataTotal,SUM(human_increment) as humanTotal  from human_data_sum t where t.idtype=? GROUP BY insertDate ORDER BY  insertDate DESC