17,086
社区成员
发帖
与我相关
我的任务
分享
select distinct a.name,nvl((select score from table_name where subject='Chinese' and name=a.name ),'') Chinese,
nvl((select scrt from table_name where subject='Chinese' and name=a.name ),'') Sort,
nvl((select score from table_name where subject='Math' and name=a.name ),'') Math,
nvl((select scrt from table_name where subject='Math' and name=a.name ),'') Sort,
nvl((select score from table_name where subject='English' and name=a.name ),'') English,
nvl((select scrt from table_name where subject='English' and name=a.name ),'') English
from table_name a
办法有点笨,但是还是可以实现目的的