--一种方式
select person_id,
max(case itemname
when '数学' then itemvalue
else
0
end) as sx,
max(case itemname
when '语文' then itemvalue
else
0
end) as yw
from Item group by person_id
--一种方式
select person_id,
max(case itemname
when '数学' then itemvalue
else
0
end) as sx,
max(case itemname
when '语文' then itemvalue
else
0
end) as yw
from Item group by person_id