查询每个专业的男生人数和女生人数分别是多少

#方式一：
select count(*) 个数,sex,majorid from student group by sex,majorid;
#方式二：
select majorid,
(select count(*) from student where sex='男' and majorid=s.majorid)男，
(select count(*) from student where sex='女' and majorid=s.majorid)女
from student s
group by majorid;

 

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。