我想要GROUP BY
jalali 的月份,所有日期在我的数据库中保存为公历格式,我发现以下 sql 查询但按公历日期分组
SELECT COUNT(reserverow.id), EXTRACT(MONTH FROM reserverow.used_date) as "Month"
FROM reserverow
WHERE reserverow.used_date > '2000-09-28 01:00:00'
GROUP BY EXTRACT(MONTH FROM reserverow.used_date)