SQL Server 按时间间隔提取数据

最新推荐文章于 2022-09-17 18:49:57 发布

菜菜菜菜菜鸡

最新推荐文章于 2022-09-17 18:49:57 发布

阅读量2.9k

点赞数 1

分类专栏： msql

本文链接：https://blog.csdn.net/qq_24084605/article/details/104968731

版权

msql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏



select  a.* from table a 
where  collectionTime between cast('2019-10-03 00:00:00' as datetime) and cast('2020-03-13 13:55:00' as datetime) 
and datediff(minute,'2019-10-03 00:00:00',a.collectionTime)%10=0 
and not exists(SELECT 1 FROM table  b 
where datediff(minute,a.collectionTime,b.collectionTime)=0 
and b.collectionTime<a.collectionTime  ) order by collectionTime asc



datediff(minute,'2019-10-03 00:00:00',a.collectionTime)%10
这段代码中间隔时间为10分钟,可根据需求,自行调整