sql分组按时间查询最近的一条

  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())

分组查询最近两个小时内最近的一条记录