语句求助sql大神

问：这种需求语句能实现吗？
答：能！

select * from table
pivot (sum(data) for code in ('语文','数学','英语'));

select distinct a.userid,b.data 语文,c.data 数学,d.data 英语
from temp_fenshu a,(select userid,data from temp_fenshu where code = '语文') b,
(select userid,data from temp_fenshu where code = '数学') c,
(select userid,data from temp_fenshu where code = '英语') d
where a.userid = b.userid(+) and
b.userid = c.userid(+) and
c.userid = d.userid(+);

select distinct a.userid,b.data 语文,c.data 数学,d.data 英语
from temp_fenshu a,(select userid,data from temp_fenshu where code = '语文') b,
(select userid,data from temp_fenshu where code = '数学') c,
(select userid,data from temp_fenshu where code = '英语') d
where a.userid = b.userid(+) and
a.userid = c.userid(+) and
a.userid = d.userid(+);