Hi Prajakta,
Do like below code.
DECLARE @lat1 decimal(18,6)
DECLARE @lon1 decimal(18,6)
SET @lat1 = 17.43969
SET @lon1 = 78.4842
SELECT TOP 5 ID, Cl_Name,@lat1,@lon1
from MyTable
ORDER BY ABS(cast(@lat1 as decimal(18,6)) - @lat1)
[Edit] By :
Nirav Prabtani
Set language code block
[/Edit]