select 2 * Asin(Sqrt(
power(
Sin((经度1-经度2)*3.1415926/180 / 2)
, 2) +
Cos(经度1*3.1415926/180) * Cos(经度2*3.1415926/180) * power(Sin((纬度1-纬度2)*3.1415926/180 / 2), 2)))*6378.137
as d
,* from 坐标表
order by d
才发现c#的pi才五位小数点。。。
不犀利啊