数据库一列多行转一行多列
时间:2022-03-10 17:17
如题:
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