SELECT DISTINCT NAME
,
(SELECT score FROM tpl_test2 son WHERE parent.name
= son.NAME
AND son.course = ‘语文’) as 语文,
(SELECT score FROM tpl_test2 son WHERE parent.name
= son.NAME
AND son.course = ‘数学’) as 数学,
(SELECT score FROM tpl_test2 son WHERE parent.name
= son.NAME
AND son.course = ‘英语’) as 英语
FROM tpl_test2 parent