**To get near by cities which are having longitude and latitude within specific distance in database**

SELECT * FROM

(

SELECT * FROM

(

SELECT *,(((acos(sin((@latitude*pi()/180)) * sin((Latitude*pi()/180))+cos((@latitude*pi()/180))

* cos((Latitude*pi()/180)) * cos(((@longitude - Longitude)*pi()/180))))*180/pi())*60*1.1515*1.609344) as distance

FROM tblCities

) t

)x where distance <= 1000

ORDER by distance