SELECT to_char(日期字段,'yyyymm'),sum(*)
FROM [TableName]
group by to_char(日期字段,'yyyymm');
ORACLE用GROUP BY 来分组日期字段 按月分组
最新推荐文章于 2023-10-30 15:47:21 发布
SELECT to_char(日期字段,'yyyymm'),sum(*)
FROM [TableName]
group by to_char(日期字段,'yyyymm');