SELECT (2*ATAN2(SQRT(SIN((-43.9043738--36.8750012)*PI()/180/2)
*SIN((-43.9043738--36.8750012)*PI()/180/2)+
COS(-36.8750012*PI()/180)*COS(-43.9043738*PI()/180)
*SIN((171.7432229-174.7514922)*PI()/180/2)
*SIN((171.7432229-174.7514922)*PI()/180/2)),
SQRT(1-SIN((-43.9043738--36.8750012)*PI()/180/2)
*SIN((-43.9043738--36.8750012)*PI()/180/2)
+COS(-36.8750012*PI()/180)*COS(-43.9043738*PI()/180)
*SIN((171.7432229-174.7514922)*PI()/180/2)
*SIN((171.7432229-174.7514922)*PI()/180/2))))*6371 AS result
[color=olive]其中6371 为地球半径单位Km,公式很简单:[/color]
[img]http://dl.iteye.com/upload/picture/pic/112003/a06f6260-a8a9-31f2-ac6b-43d3cdc36529.png[/img]