java------4.根据经纬度排序，并计算距离。。。。。。。。根据地址计算出经纬度

select xs.*,sqrt ((((118.9136869871-xs.qps_log)*PI()*12656*COS(((32.0842566206+xs.qps_lat)/2)*PI()/180)/180)*((118.9136869871-xs.qps_log)*PI()*12656*COS(((32.0842566206+xs.qps_lat)/2)*PI()/180)/180))+( ((118.9136869871-xs.qps_lat)*PI()*12656/180)*((32.0842566206-xs.qps_lat)*PI()*12656/180) ) ) as juli from t_qps xs
select xs.*,sqrt ((((118.913686987