oracle查询如何将多种类型对应的结果在一条记录中展示出来?(比如表中有年份、类型、产值,查询结果显示想要的是年、类型A、产值A、类型B、产值B,类型C,,,,,)
解决方案 »
- 请教定时job问题??????
- 谁能给我一个oracle论坛的邀请码呀
- Encountered the symbol "+" when expecting one of the following:(The symbol "(" was substituted for "+" to continue. oracle报错
- pL/SQL DEVELOPER 7中 中文字符拷贝到其它软件例如Notepad会显示为乱码?
- oracle存储过程参数为blob类型 遇到参数大小问题
- 【求助】2个表简单合并的sql语句
- 谁能解释一下decode和sign的用法?
- 问一个oracle数据类型转换的问题
- 如何从脚本中创建数据库的表
- 字段的动态执行
- SQL求教。急急急急急!
- 在算一个平均住院日的指标,求给个思路.
INSERT INTO t VALUES (2016, 'A', 500);
INSERT INTO t VALUES (2016, 'B', 600);
INSERT INTO t VALUES (2016, 'C', 700);
INSERT INTO t VALUES (2017, 'A', 800);
INSERT INTO t VALUES (2017, 'B', 900);SELECT year, '类型A', pa, '类型B', pb, '类型C', pc
FROM (SELECT year, TYPE, production
FROM t
)
PIVOT (SUM(production) FOR (type) IN ('A' AS pa, 'B' AS pb, 'C' AS pc))
ORDER BY year;YEAR |'类型A' |PA |'类型B' |PB |'类型C' |PC |
-----|------|----|------|----|------|----|
2016 |类型A |500 |类型B |600 |类型C |700 |
2017 |类型A |800 |类型B |900 |类型C | |