SQL行转列备忘

firehou

于 2011-12-15 23:36:10 发布

阅读量932

点赞数

分类专栏：数据库文章标签： sql null c

本文链接：https://blog.youkuaiyun.com/firehou/article/details/7075882

版权

数据库专栏收录该内容

12 篇文章

订阅专栏

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