求一条sql语句！请进！！要oracle版的,刚才问错了问了sql版的!!

Question

SQL> C1         C2
---------- ----------
A          1
A          1
C          3
D          1
B          4
B          2
C          2
C          2
A          2
A          410 rows selectedExecuted in 0.032 secondsSQL> 等级                A          B          C          D          E       总计
---------- ---------- ---------- ---------- ---------- ---------- ----------
1                   2          0          0          1          0          3
2                   1          1          2          0          0          4
3                   0          0          1          0          0          1
4                   1          1          0          0          0          2Executed in 0.016 secondsSQL>

Answer 1

select sum(decode(种类,a,1,0)) a,sum(decode(种类,b,1,0)) b,
       sum(decode(种类,c,1,0)) c,sum(decode(种类,d,1,0)) d,
       sum(decode(种类,e,1,0)) e,count(*) "总计"
from t 
group by 等级

Answer 2

SQL> 等级                A          B          C          D          E       总计
---------- ---------- ---------- ---------- ---------- ---------- ----------
1                   2          0          0          1          0          3
2                   1          1          2          0          0          4
3                   0          0          1          0          0          1
4                   1          1          0          0          0          2
总计                4          2          3          1          0         10Executed in 0.016 secondsSQL

Answer 3

最简单的交叉表问题了，按照‘duanzilin(寻) ’的思路没错！