oracle分组查询

[dr_lou]

dpart uname usex
A a1 1
A a2 1
A a3 0
A a4 0
A a5 1
B b1 0
B b2 1

希望实现
dpart sex1 sex0 sum
A 3 2 5
B 1 1 2

求sql语句

[shiyiwan]

select dpart, sum(case when usex=1 then 1 end) sex1, sum(case when usex=0 then 1 end) sex0, count(usex) sum from t group by dpart;

[小灰狼W]

select dpart,
count(decode(usex,1,1))sex1,
count(decode(usex,0,1))sex0,
count(1)sum
from tt
group by dpart