1.新建一个名为TEST表
2.向TEST表中添加数据
INSERT INTO TEST(STUDENT,COURSE,SCORE)select '张三','语文',78 from dual unionselect '张三','数学',87 from dual union select '张三','英语',82 from dual unionselect '张三','物理',90 from dual unionselect '李四','语文',65 from dual unionselect '李四','数学',77 from dual unionselect '李四','英语',65 from dual unionselect '李四','物理',85 from dual
表数据如下:
3.列转行
方法··1:
select Student, sum(decode(Course, '数学', Score)) 数学......
阅读全文