select * from (
select ROW_NUMBER() OVER(Order By [datetime] desc) as RowRank ,[datetime],sum(case [sensorid] when 16 then transvalue else NUll end) c16
,sum(case [sensorid] when 18 then transvalue else NUll end) c18
from SensorDatas where convert(varchar(10),
[datetime], 120)='2011-11-10' group by [datetime] )
v where v.RowRank>=0 SQL行转列备忘
最新推荐文章于 2024-11-06 18:49:05 发布
扫一扫
226
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
