日期:2014-05-18 浏览次数:20413 次
select top 1 * from tb order by abs(90.45-[坐标X])+abs(20.22-[坐标Y])
------解决方案--------------------
select top 1 * from tab order by sqrt(power(坐标X-90.5,2)+power(坐标Y-20.22,2))
------解决方案--------------------
select top 1 * from tb order by ((x - 90.45 )*(x - 90.45 ) + (y - 20.22)*(y - 20.22))