sqlserver 獲取每組最接近某個(gè)時(shí)間點(diǎn)的一條數(shù)據(jù)
with T1 as ( SELECT ROW_NUMBER() over (PARTITION By MachineCode order by ABS(DATEDIFF(MILLISECOND,'2019-12-10 13:21:32.162' ,[Time]))) as rowid,* FROM EnergyConsumptions ) select * from T1 where rowid=1
Newd
版權(quán)聲明
地址:http://www.rzrgm.cn/Newd/p/12932049.html
? Newd 尊重知識(shí)產(chǎn)權(quán),引用請(qǐng)注出處
廣告位
(虛位以待,如有需要請(qǐng)私信)
浙公網(wǎng)安備 33010602011771號(hào)