select
 loc.DISTRICT_CODE as CODE
 ,dist.DISTRICT_NAME as NAME
 ,loc.LATITUDE as LAT
 ,loc.LONGITUDE as LON
from
 LOCATION_TBL loc
left join
 DISTRICT dist
on
 loc.DISTRICT_CODE = dist.DISTRICT_CODE
left outer join
 (
  select
   sub.LATITUDE
   ,sub.LONGITUDE
  from
   LOCATION_TBL sub
  where
   DISTRICT_CODE = '1101'
 ) chuo
where
 loc.DISTRICT_CODE != '1101'
order by
 abs( POW(LAT,2) -2*LAT*chuo.LATITUDE + POW(chuo.LATITUDE,2) + POW(LON,2) -2*LON*chuo.LONGITUDE + POW(chuo.LONGITUDE,2)) desc
 ,loc.DISTRICT_CODE