sql 按年月分组

SELECT date_num/12 [year], date_num%12+1 [month], num FROM( SELECT YEAR(register_date)*12+MONTH(register_date)-1 date_num,count(*) num FROM [user] GRO
posted @ 2022-01-12 19:07  SHHHS  阅读(236)  评论(0)  编辑  收藏  举报