select partid,max(decode(gender,'男',num,0)) 男,max(decode(gender,'女',num,0)) 女
from (select partid,gender,count(1) num from users a,sales b where a.salesid = b.id group by partid,gender)
group by partid;
[Quote=引用 3 楼 lengyunfei006 的回复:]
不好意思,看的马虎了。
select b.partid,
sum(a.gender, '男', 1, 0) 男,
sum(a.gender, '女', 1, 0) 女,
from users a, sales b
where a.salesid = b.id
group by b.partid