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
原文：https://www.cnblogs.com/Newd/p/12932049.html