34,588
社区成员
发帖
与我相关
我的任务
分享
select school.schoolName,class.ClassName, student.sex,count(student.sex) from student
inner join class on class.classId= student.classid
inner join school on school.schoolId=class.schoolId
group by school.schoolName,class.ClassName,student.sex
select
schoolID,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
schoolID,classID
select schoolID,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 schoolID,classID
select 分组字段....,
sum(case when sex=1 then 1 else 0 end) '男',
sum(case when sex=0 then 1 else 0 end) '女'
from tb
...表连接。。。
group by 分组字段