按月份统计数据
取日期的月份函数to_char(t.Dcoldate,‘mm’)
SELECT to_char(t.Dcoldate,‘mm’),sum(jixiao) FROM A t WHERE t.pid = ‘88888’ and t.Dcoldate>date’2019-01-01’ group by to_char(t.Dcoldate,‘mm’) ;
按日期所在的月份统计数据
最新推荐文章于 2022-11-16 15:32:55 发布
按月份统计数据
取日期的月份函数to_char(t.Dcoldate,‘mm’)
SELECT to_char(t.Dcoldate,‘mm’),sum(jixiao) FROM A t WHERE t.pid = ‘88888’ and t.Dcoldate>date’2019-01-01’ group by to_char(t.Dcoldate,‘mm’) ;