Question

oracle 怎么把值设置成列名

原表
id | name | subject | score
----------------------------------
1 | zhangs | chinese | 80
1 | zhangs | math | 80
1 | zhangs | english | 80
2 | lisi | chinese | 90
2 | lisi | math | 90
2 | lisi | english | 90
3 | wangw | chinese | 70
3 | wangw | math | 70
3 | wangw | english | 70

效果
id | name | chinese | math | english
-----------------------------------------
1 | zhangs | 80 | 80 | 80
2 | lisi | 90 | 90 | 90
3 | wangw | 70 | 70 | 70

哪位高手指定下

Answer 1

select id,name,
decode(subject,'chinest',score) chinese,
decode(subject,'math',score) math,
decode(subject,'english',score) english
from TABLENAME;
你的字段都在一张表中，不好像不需要表连接，刚学的，你试试可以不，呵呵