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

如题：

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

数据库一列多行转一行多列,布布扣,bubuko.com

原文：http://blog.csdn.net/zhao50632/article/details/26579837