select D,K ,nvl(sum(decode(L,'轿车',C)),0) as "轿车-C" ,nvl(sum(decode(L,'轿车',J)),0) as "轿车-J" ,nvl(sum(decode(L,'轿车',Y)),0) as "轿车-Y" ,nvl(sum(decode(L,'轿车',Q)),0) as "轿车-Q" ,nvl(sum(decode(L,'越野',C)),0) as "越野-C" ,nvl(sum(decode(L,'越野',J)),0) as "越野-J" ,nvl(sum(decode(L,'越野',Y)),0) as "越野-Y" ,nvl(sum(decode(L,'越野',Q)),0) as "越野-Q" from table group by D,K
select D,K
,nvl(sum(decode(L,'轿车',C)),0) as "轿车-C"
,nvl(sum(decode(L,'轿车',J)),0) as "轿车-J"
,nvl(sum(decode(L,'轿车',Y)),0) as "轿车-Y"
,nvl(sum(decode(L,'轿车',Q)),0) as "轿车-Q"
,nvl(sum(decode(L,'越野',C)),0) as "越野-C"
,nvl(sum(decode(L,'越野',J)),0) as "越野-J"
,nvl(sum(decode(L,'越野',Y)),0) as "越野-Y"
,nvl(sum(decode(L,'越野',Q)),0) as "越野-Q"
from table
group by D,K