SELECT to_char(日期字段,'yyyymm'),sum(*)
FROM [TableName]
group by to_char(日期字段,'yyyymm');
FROM [TableName]
group by to_char(日期字段,'yyyymm');
SELECT to_char(日期字段,'yyyymm'),sum(*)
FROM [TableName]
group by to_char(日期字段,'yyyymm');
FROM [TableName]
group by to_char(日期字段,'yyyymm');