SELECT
TOP 5 *, ACOS(
SIN(
(39.929875 * PI()) / 180
) * SIN(
(LAT * PI()) / 180
) COS(
(39.929875 * PI()) / 180
) * COS(
(LAT * PI()) / 180
) * COS(
(116.312785 * PI()) / 180 - (LONG * PI()) / 180
)
) * 6380 AS aa
FROM
CENTER
WHERE
LAT > 39.929875 - 1
AND LAT <39.929875 1
AND LONG >116.312785 - 1
AND LONG < 116.312785 1
ORDER BY aa
---------------------------------------------------------------------------------------
若数据类型不是float型,需要转换为float型:CAST(LAT AS FLOAT)
