PostgreSQL 实现按月按年，按日统计分组统计

最新推荐文章于 2025-02-01 09:41:27 发布

二苟

最新推荐文章于 2025-02-01 09:41:27 发布

阅读量2.7w

点赞数 4

分类专栏： postgre

本文链接：https://blog.csdn.net/aleefang/article/details/78679402

版权

本文整理了PostgreSQL中如何按照月份、年份及日期进行数据的分组统计，主要聚焦在时间维度的数据分析操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

参考博客园的文章，暂时在这里整理一下，后期再做补充。

--按年分组查看

   select to_char(time_field, 'YYYY') as d , count(id) as total_count,sum (count_field) as total_amount from table_name
where time_field between start_time and end_time group by d

--按月分组查看
   select to_char(time_field, 'YYYY-MM') as d , count(id) as total_count,sum (count_field)   as total_amount from table_name
where time_field between start_time and  end_time group by d

--按天分组查看
   select to_char(time_field, 'YYYY-MM-DD') as d , count(id) as total_count,sum (count_field)   as total_amount from table_name
where time_field between start_time and  end_time group by d

--按小时分组查看
     select to_char(time_field, 'YYYY-MM-DD HH24 ' ) as d , count(id) as total_count,sum (count_field)   as total_amount from table_name
whe