班级姓名性别，写sql统计出每个班分别有男女生各多少名

Question

如题所述

Answer 1

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本回答被网友采纳

Answer 2

select Cla,

count(case when Ssex=1 then 1 else 0 end) as '男',

count(case when Ssex=2 then 1 else 0 end) as '女'

from student group by Cla