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(chuo.LATITUDE - LAT,2) + POW(chuo.LONGITUDE - LON,2)) desc
 ,loc.DISTRICT_CODE