select TimeStamp,value from ( select row_number() over(order by TimeStamp,value) as rk, TimeStamp,value from tb ) t where t.rk<=2
select TimeStamp,value from ( select rank() over(partition by tt order by TimeStamp,value) as rk,TimeStamp,value from ( select convert(varchar(13),TimeStamp,120) as tt, TimeStamp,value from tb ) t ) q where rk<=2----应该是用rank()
select TimeStamp,value from ( select rank() over(partition by tt order by TimeStamp,value) as rk,TimeStamp,value from ( select convert(varchar(13),TimeStamp,120) as tt, TimeStamp,value from tb ) t ) q where rk<=2
select TimeStamp,value from ( select row_number() over(order by TimeStamp) as row_number, TimeStamp,value from tb ) t where t.value<>(select value from (select row_number() over(order by TimeStamp) as row_number, TimeStamp,value from tb) t1 where t1.row_number=t.row_number-1)
select row_number() over(order by TimeStamp,value) as rk, TimeStamp,value from tb
) t where t.rk<=2
select rank() over(partition by tt order by TimeStamp,value) as rk,TimeStamp,value from (
select convert(varchar(13),TimeStamp,120) as tt, TimeStamp,value from tb
) t
) q where rk<=2----应该是用rank()
select rank() over(partition by tt order by TimeStamp,value) as rk,TimeStamp,value from (
select convert(varchar(13),TimeStamp,120) as tt, TimeStamp,value from tb
) t
) q where rk<=2
select row_number() over(order by TimeStamp) as row_number, TimeStamp,value from tb
) t
where t.value<>(select value from
(select row_number() over(order by TimeStamp) as row_number, TimeStamp,value from tb) t1
where t1.row_number=t.row_number-1)