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