阅读背景:

How to get all other postcodes or (latitude & longitude) from table near by given postcode and given radius in miles in sql server?

来源:互联网 

I have table with latitude,longitude and postcodes. I want select the records which are near by given postcode and radius in miles. e.g user will give inputs postcode = 'NW44JL' and radius = 1 mile. I need to get all the records from the table with in 1 mile radius of postcode 'NW44JL'. Can anyone help me to get this. ThanksI have table with latitude,longitude and postco




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: