with t_rowtable
as
(
select row_number() over(order by ItemTime) as row_number,* from test6.dbo.fengsu
)
as
(
select row_number() over(order by ItemTime) as row_number,* from test6.dbo.fengsu
)
select * from t_rowtable where row_number%500 = 0 order by ItemTime
t_rowtable是一个临时表。每隔500条数据取一个记录,这些记录是按照ItemTime排序