select Id, TimeStampfrom ISAliveWHERe RecordUpdatedDate = dateadd(minute,-10,getdate())
可能是一个起点。当然,它可能不会完全匹配…
…如果您想获取符合该条件的最新记录,请尝试
SELECT TOP 1 ID, TimeStampFROM ISAliveWHERe RecordUpdatedDate <= dateadd(minute, -10, getdate())ORDER BY RecordUpdatedDate DESC



