select sum(decode(a.民族,'汉族',a.人数,0)) as 汉族, sum(decode(a.民族,'枪族',a.人数,0)) as 枪族, sum(decode(a.民族,'回族',a.人数,0)) as 回族, sum(decode(a.民族,'彝族',a.人数,0)) as 彝族 from table a
select sum(decode(a.民族,'汉族',a.人数,0)) as 汉族, sum(decode(a.民族,'枪族',a.人数,0)) as 枪族, sum(decode(a.民族,'回族',a.人数,0)) as 回族, sum(decode(a.民族,'彝族',a.人数,0)) as 彝族 from table a;
sum(decode(a.民族,'汉族',a.人数,0)) as 汉族,
sum(decode(a.民族,'枪族',a.人数,0)) as 枪族,
sum(decode(a.民族,'回族',a.人数,0)) as 回族,
sum(decode(a.民族,'彝族',a.人数,0)) as 彝族
from table a
sum(decode(a.民族,'汉族',a.人数,0)) as 汉族,
sum(decode(a.民族,'枪族',a.人数,0)) as 枪族,
sum(decode(a.民族,'回族',a.人数,0)) as 回族,
sum(decode(a.民族,'彝族',a.人数,0)) as 彝族
from table a;
这一类型的转换可能要借助于PL/SQL来完成
没试过,从网上搜搜