with base as (
select distinct
  LATITUDE as LAT
 ,LONGITUDE as LON
from
    LOCATION_TBL as main
where
  DISTRICT_CODE = '1101'
)
select
  DISTRICT_CODE as CODE
 ,DISTRICT_NAME as NAME
 ,LATITUDE as LAT
 ,LONGITUDE as LON
from
    LOCATION_TBL as main
inner join
    DISTRICT as dist using(DISTRICT_CODE)
cross join
    base
where
    DISTRICT_CODE <> '1101'
order by
     abs( POW(LATITUDE-base.LAT, 2) + POW(LONGITUDE-base.LON, 2) ) desc
    ,DISTRICT_CODE asc