select 
  LOCATION_TBL.DISTRICT_CODE as CODE,
  DISTRICT_NAME as NAME,
  LOCATION_TBL.LATITUDE as LAT,
  LOCATION_TBL.LONGITUDE as LON
from   LOCATION_TBL
join   (
  select * 
  from  LOCATION_TBL 
  where DISTRICT_CODE = '1101'
) as base
on LOCATION_TBL.DISTRICT_CODE != base.DISTRICT_CODE
join DISTRICT
on   DISTRICT.DISTRICT_CODE = LOCATION_TBL.DISTRICT_CODE
order by
pow(LOCATION_TBL.LATITUDE - base.LATITUDE, 2) + 
pow(LOCATION_TBL.LONGITUDE - base.LONGITUDE, 2) desc,
 LOCATION_TBL.DISTRICT_CODE  
;