oracle数据报表横竖转换

 select p, sum(decode(a, 20, c, 0)) as "20",
          sum(decode(a, 50, c, 0)) as "50"
  from (select t2.provincename p, t1.amount / 100 a, count(*) c
          from tab1, tab2 t2
         where t1.provinceno = t2.provinceno
         group by t2.provincename, t1.amount) v
 group by p;

 说白了，就是decode的使用，其他没什么了

 

鼓捣了好久才弄出来，不知道放哪里好找，电脑上很乱，就放这里一下