select top 10 week, 北京=max(case when address='北京' then state end),广州=max(case when address='广州' then state end) from State group by week
如何将这个slq语句写成存储过程,因为address的值比较多,不可能一个一个来写的。正个语句,刚才发错了。
如何将这个slq语句写成存储过程,因为address的值比较多,不可能一个一个来写的。正个语句,刚才发错了。
set @sql=''
select @sql=@sql+',['+address+']=max(case when address='''+address+''' then state end)'
from State group by address
set @sql='select top 10 week'+@sql+' from State group by week'
exec(@sql)
谢谢你了。~问题解决~