mssql中任何查找最近点问题
表
ID col creatime
现在给出一个时间作为查询条件 ,任何查找出最接近这个时间的记录
[解决办法]
with tb as
(
select *, ABS(Datediff(SECOND, 表.creatime, 你给入的时间)) as diff from 表
)
select top 1 *
from tb
order by diff
