17,377
社区成员
发帖
与我相关
我的任务
分享
select name ,
SUM(decode(course,'yuwen',score,0)) 'yuwen,
SUM(decode(course,'shuxue',score,0)) shuxue,
SUM(decode(course,'yingyu',score,0)) yingyu
from grate
group by name
select name ,
SUM(decode(course,'语文',score,‘null')) 语文,
SUM(decode(course,'数学',score,‘null')) 数学,
SUM(decode(course,'英语',score,‘null')) 英语
from t
group by name
select name ,
SUM(decode(course,'语文',score,0)) 语文,
SUM(decode(course,'数学',score,0)) 数学,
SUM(decode(course,'英语',score,0)) 英语
from t
group by name