近一年(12个月)项目数量统计,按月份,同时将月份格式化
select to_char(create_time, 'YYYY-MM') as createDate,count(id) as count
from project_info group by createDate order by createDate desc limit 12
近一年(12个月)项目数量统计,按月份,同时将月份格式化
select to_char(create_time, 'YYYY-MM') as createDate,count(id) as count
from project_info group by createDate order by createDate desc limit 12