需求:对一个调查表中其中一个问题的调查结果分类求和
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