select classID,
sum(case when sex=1 then 1 else 0 end) as '男',
sum(case when sex=2 then 1 else 0 end) as '女'
from student group by classID
转载于:https://www.cnblogs.com/123456p/p/8649156.html
统计出每个班分别有男女生各多少名
最新推荐文章于 2022-07-18 12:43:18 发布
select classID,
sum(case when sex=1 then 1 else 0 end) as '男',
sum(case when sex=2 then 1 else 0 end) as '女'
from student group by classID
转载于:https://www.cnblogs.com/123456p/p/8649156.html
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
1万+
