select 班级 from class group by 班级 having sum(male*2-1)=0
select classname, sum(case male when 0 then 1 else 0 end) as Boys, sum(case male when 1 then 1 else 0 end) as Girls, from class group by male having Boys=Girls试试这样看。贴出你的测试数据来,大家好做实验。
你的我试了,可以啊,请问写出这样SQL语句的思路是什么样子的啊,我真崇拜你们啊
select 班级 from class group by 班级 having sum(male*2-1)=0这个会答得真是妙哉!
from class
group by 班级
having sum(male*2-1)=0
select classname,
sum(case male when 0 then 1 else 0 end) as Boys,
sum(case male when 1 then 1 else 0 end) as Girls,
from class
group by male
having Boys=Girls试试这样看。贴出你的测试数据来,大家好做实验。
你的我试了,可以啊,请问写出这样SQL语句的思路是什么样子的啊,我真崇拜你们啊