------解决方案--------------------
select name,
sum(decode(course, '数学', num, 0)) 数学,
sum(decode(course, '语文', num, 0)) 语文,
sum(decode(course, '英语', num, 0)) 英语
from tab
group by name
------解决方案--------------------
select * from user_cour;
select name,
sum(decode(course, '数学', num, 0)) 数学,
sum(decode(course, '语文', num, 0)) 语文,
sum(decode(course, '英语', num, 0)) 英语
from user_cour
group by name
very good! test is ok!