MySQL:
例子:表名-xs_shop 字段-latitude纬度 longitude经度 定位的经纬度:22.72114,114.2308
SELECT
s.*,(
6371 * acos (
cos ( radians(22.72114) )
* cos( radians( s.latitude ) )
* cos( radians( s.longitude ) - radians(114.2308) )
+ sin ( radians(22.72114) )
* sin( radians( s.latitude ) )
)
) AS distance
FROM xs_shop s
ORDER BY distance
LIMIT 0 , 2000;
LIMIT 0 , 2000----范围
Oracle:
例子:表名-xs_shop 字段-latitude纬度 longitude经度 定位的经纬度:22.72114,114.2308
1.
select s.*,
(2*asin(sqrt(power(sin((114.2308-s.longitude)*3.14159265359/180/2),2)
+cos(22.72114*3.14159265359/180)
*cos(s.latitude*3.14159265359/180)
*power(sin((22.72114-s.latitude)
*3.14