[sql 查询问题]速度来

[dengjun55]

一个很菜的问题
sql题目
：
一张表的字段有id，uname,partment,sex
这四个字段，查询在一个部门中性别人数相等的部门

如图：

[hery2002]

select partment ,sum(case when sex ='男' then 1 else 0 end) as '男' ,sum(case when sex ='女' then 1 else 0 end) as '女'
from tb where sum(case when sex ='男' then 1 else 0 end) as '男' = sum(case when sex ='女' then 1 else 0 end) as '女' 
group by partment 

[zoujp_xyz]

[Quote=引用 1 楼 hery2002 的回复:]
SQL codeselect partment ,sum(case when sex ='男' then 1 else 0 end) as '男' ,sum(case when sex ='女' then 1 else 0 end) as '女'
from tb where sum(case when sex ='男' then 1 else 0 end) as '男' = sum(case when sex ='女' then 1 else 0 end) as '女' 
group by partment 
[/Quote]

[ChinaITOldMan]

select partment ,sum(case when sex ='男' then 1 else 0 end) as '男' ,sum(case when sex ='女' then 1 else 0 end) as '女'
from tb where sum(case when sex ='男' then 1 else 0 end) as '男' = sum(case when sex ='女' then 1 else 0 end) as '女'
group by partment


hery2002这种方法很好很优秀