select sum(decode(year,'2001',renkou,0)) "2001", sum(decode(year,'2002',renkou,0)) "2002", sum(decode(year,'2003',renkou,0)) "2003" from tab union all select sum(decode(year,'2001',baifenbi,0)) , sum(decode(year,'2002',baifenbi,0)) , sum(decode(year,'2003',baifenbi,0)) from tab 若renkou或baifenbi中有字符,那么再加上to_char转化,to_char(sum(..))
sum(decode(year,'2002',renkou,0)) "2002",
sum(decode(year,'2003',renkou,0)) "2003"
from tab
union all
select sum(decode(year,'2001',baifenbi,0)) ,
sum(decode(year,'2002',baifenbi,0)) ,
sum(decode(year,'2003',baifenbi,0))
from tab 若renkou或baifenbi中有字符,那么再加上to_char转化,to_char(sum(..))