4条回答 默认 最新
- CSDN专家-赖老师(软件之家) 2021-06-11 08:48关注
select year(birth) ,count(*) cnt from 学生表 where 性别='男' group by year(birth) having count(*)>3 order by cnt,year(birth) ;
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
select year(birth) ,count(*) cnt from 学生表 where 性别='男' group by year(birth) having count(*)>3 order by cnt,year(birth) ;