select t.* from (select * ,row_number() over (partition by FID order by SW_MEASURE_TME desc) as rn
from SWLSDTJC) t
where rn<=1 and SW_MEASURE_TME > DATEADD(HOUR,-2,GETDATE())
分组查询最近两个小时内最近的一条记录
select t.* from (select * ,row_number() over (partition by FID order by SW_MEASURE_TME desc) as rn
from SWLSDTJC) t
where rn<=1 and SW_MEASURE_TME > DATEADD(HOUR,-2,GETDATE())
分组查询最近两个小时内最近的一条记录