--间隔取记录
select DiffWeight from (select * from(select row_number() over
(order by thisTime) as rn,* from t_SaveRecordData2019) as rn ) as s
where rn%127=1 and ThisTime>='2019-12-24 12:00:00' AND ThisTime<='2019-12-30'
--间隔取记录
select DiffWeight from (select * from(select row_number() over
(order by thisTime) as rn,* from t_SaveRecordData2019) as rn ) as s
where rn%127=1 and ThisTime>='2019-12-24 12:00:00' AND ThisTime<='2019-12-30'