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
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/12103.html
