oracle行转列

select

    Student,

    sum(case Course when '数学' then Score else null end) 数学,

    sum(case Course when '物理' then Score else null end) 物理,

    sum(case Course when '英语' then Score else null end) 英语,

    sum(case Course when '语文' then Score else null end) 语文

from 

    TEST 

group by Student

 

链接：https://www.cnblogs.com/Mr_JinRui/archive/2011/05/27/2060109.html