select
   D.DISTRICT_CODE as CODE
 , D.DISTRICT_NAME as NAME
 , L2.LATITUDE as LAT
 , L2.LONGITUDE as LON
from
   LOCATION_TBL as L1
 ,  LOCATION_TBL as L2
   inner join DISTRICT as D
     on D.DISTRICT_CODE = L2.DISTRICT_CODE
where
      L1.DISTRICT_CODE  = '1101'
 and  L2.DISTRICT_CODE  <> '1101'
order by
  POW(L1.LATITUDE - L2.LATITUDE, 2) + POW(L1.LONGITUDE - L2.LONGITUDE, 2) desc
, D.DISTRICT_CODE asc;