oracle·Ö×é²éѯ

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Óï¾ä

---

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;

---

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