我在SQL server中每1秒存储一次数据,我需要每1到2分钟间隔获取数据,而不是几秒,如何使用sql每2分钟获取一次数据?
发布于 2019-05-29 02:38:33
select *
from
(
select *,
datepart(minute, yourDate) mn,
row_number() over(partition by datepart(minute, yourDate) order by yourDate) rn
from yourTable
) x
where (mn % 2) = 0
and rn = 1
发布于 2019-05-29 03:30:50
我会这样做:
select t.*
from (select t.*,
row_number() over (partition convert(date, datecol), datepart(hour, datecol), datepart(minute, datecol) / 2
order by datecol
) as seqnum
from t
) t
where seqnum = 1;
partition by
将数据分成组,每组两分钟( / 2
会这样做)。然后,该逻辑返回每个组中的第一条记录。
https://stackoverflow.com/questions/56348167
复制相似问题