如何获取最接近指定时间的一组记录

[wen1512]

比如我给个时间参数'2014-06-20 16:02:00.000',如何查询出RecordTime_dt最接近这个时间的一组记录.

[--小F--]

select top 1 * from tb order by abs(datediff(ss,RecordTime_dt,'2014-06-20 16:02:00.000')

[wen1512]

如何根据TankNo_ch分组获取一组数据呢

[AcHerat]

select *
from (
    select *,rid = row_number() over (order by abs(datediff(ss,RecordTime_dt,'2014-06-20 16:02:00.000')))
    from tb
) tmp
where rid <= 1

[wen1512]

引用 1 楼 fredrickhu 的回复:

select top 1 * from tb order by abs(datediff(ss,RecordTime_dt,'2014-06-20 16:02:00.000')

如何根据TankNo_ch分组获取一组数据呢

[AcHerat]

select *
from (
    select *
           ,rid = row_number() over (partition by TankNo_ch order by abs(datediff(ss,RecordTime_dt,'2014-06-20 16:02:00.000')))
    from tb
) tmp
where rid = 1