不一定对，只有2142条数据

原创于 2025-08-03 23:40:20 发布 · 99 阅读

CC 4.0 BY-SA版权

文章标签：

select * from t_m1 where id  between 4930000 and 4940000


SELECT *
FROM (
    SELECT *,
           ROW_NUMBER() OVER (PARTITION BY CONVERT(DATE, TradingDay), DATEPART(HOUR, UpdateTime)
                              ORDER BY InstrumentID asc, TradingDay asc ) seqnum
    FROM t_m1 as t
   
) as t1
WHERE seqnum = 1 order by InstrumentID asc, TradingDay asc ;


SELECT *
FROM (
    SELECT *,
           ROW_NUMBER() OVER (PARTITION BY CONVERT(DATE, TradingDay), DATEPART(minute, UpdateTime)
                              ORDER BY InstrumentID asc, TradingDay asc ) seqnum
    FROM t_m1 as t
   
) as t1
WHERE seqnum = 1 order by InstrumentID asc, TradingDay asc ;