数据库一列多行转一行多列

如题：

select
max(case when name='1' then [temp] else null end) as temp1
, max(case when name='2' then [temp] else null end) as temp2,
 max(case when name='3' then [temp] else null end) as temp3
from historyt group by time