SELECT DATE_FORMAT(年月日的字段, '%Y') AS year,
COUNT(ROWGUID) AS num
FROM 表明
GROUP BY year
ORDER BY year ASC
Mybatis(MySQL) 查询按年分组统计并排序
最新推荐文章于 2024-07-24 11:55:50 发布
SELECT DATE_FORMAT(年月日的字段, '%Y') AS year,
COUNT(ROWGUID) AS num
FROM 表明
GROUP BY year
ORDER BY year ASC