SQL Server 按時間間隔提取資料進行資料採樣，sqlserver

SQL Server 按時間間隔提取資料進行資料採樣，sqlserver

Select Ana1,RdDate,RdTime,cast(convert(varchar,RdDate,112)+' '+convert(varchar,RdTime,108) as datetime) as time,t.interval FROM (SELECT Ana1,RdDate,RdTime, datediff (mi,cast(convert(varchar,RdDate,112)+' '+convert(varchar,RdTime,108) as datetime), GETDATE()) AS interval  FROM Records ) AS t WHERE t.interval%10 = 0  //擷取間隔十分鐘的資料，但是擷取之後分鐘相同的還會有重複，仍需進一步處理