有如下表:id name desc
1 a y
1 a y
2 b x
2 c x
3 d x
3 d xresult:id name desc desc2 countdesc countdesc2
1 a 0 y 0 2
2 b x 0 1 0
2 c x 0 1 0
3 d x 0 2 0
1 a y
1 a y
2 b x
2 c x
3 d x
3 d xresult:id name desc desc2 countdesc countdesc2
1 a 0 y 0 2
2 b x 0 1 0
2 c x 0 1 0
3 d x 0 2 0
select id,名称,类型1,count(类型1) as 类型1数量,类型2,count(类型2) as 类型2数量
from (select id,名称,decode(类型,x,x,0) as 类型1,
decode(类型,y,y,0) as 类型2
from tb)
group by id,名称,类型1,类型2
转过来了