一个简单的行列转换例子...
[@more@]SQL> select * from test;
ID NAME
---------- ----------
12 a
17 a
3 b
19 a
79 c
8 b
6 rows selected.
SQL> select sum(decode(name,'a',id,0)) a,
2 sum(decode(name,'b',id,0)) b,
3 sum(decode(name,'c',id,0)) c
4 from (select id,name,
5 row_number()over(partition by name order by id) rn
6 from test)
7 group by rn;
A B C
---------- ---------- ----------
12 3 79
17 8 0
19 0 0
3 rows selected.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7988176/viewspace-921887/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量29
-
访问量341609
