– 按自然月统计2019年每月28号数据
select to_char(a.charge_date, ‘YYYY-MM’) as 月份, count(1) as 数量
from a
WHERE to_char(a.charge_date, ‘YYYY’) = 2019
and to_char(a.charge_date, ‘DD’) = 28
GROUP BY to_char(a.charge_date, ‘YYYY-MM’)
order by to_char(a.charge_date, ‘YYYY-MM’);
统计2020年每月28号的数据
最新推荐文章于 2024-04-27 23:19:29 发布