oracle如何查询这种结果

Question

年度 季度 销量
1991 1 20
1991 2 79
1991 3 60
1991 4 68
1992 1 56
1992 2 54用一个sql语句查询成这样的结果年份 1季度 2季度 3季度 4季度
1991 20 79 60 68
1992 56 54 

Answer 1

select 年度 年份,sum(decode(季度,1,销量,0))  1季度,
                sum(decode(季度,2,销量,0))  2季度,
                sum(decode(季度,3,销量,0))  3季度,
                sum(decode(季度,4,销量,0))  4季度
from table
group by 年度

Answer 2

SQL> select year,sum(decode(ji,1,sale,null)) "1季度",
  2  sum(decode(ji,2,sale,null)) "2季度",
  3  sum(decode(ji,3,sale,null)) "3季度",
  4  sum(decode(ji,4,sale,null)) "4季度"
  5  from test
  6  group by year;      YEAR      1季度      2季度      3季度      4季度
---------- ---------- ---------- ---------- ----------
      1991         20         79         60         56
      1992         80         54

Answer 3

可以借鑒這個帖http://topic.csdn.net/u/20100811/10/2bde6322-3fe7-4ab5-88ca-a37dafbbf805.html?seed=1940981632&r=67620743#r_67620743

Answer 4

表
SQL> select * from test;      YEAR         JI       SALE
---------- ---------- ----------
      1991          1         20
      1991          2         79
      1991          3         60
      1991          4         56
      1992          1         80
      1992          2         54已选择6行。