把查询结果列转换为行

 需求：对一个调查表中其中一个问题的调查结果分类求和

　　1.按列显示　

　　　SELECT SJ1, COUNT(*) FROM TABLE GROUP BY SJ1

           显示结果
             A       1
            B       22
            C       55
            D       53
            E       14           

      2.按行显示

　　　select sum(decode(sj1,'A', 1,0)) "A",
                   sum(decode(sj1,'B', 1,0)) "B",
                   sum(decode(sj1,'C', 1,0)) "C",
                   sum(decode(sj1,'D', 1,0)) "D",
                   sum(decode(sj1,'E', 1,0)) "E",
                   from TABLE

             显示结果
            A         B         C         D             E
           1          22       55         53           14