select 
  LOCATION_TBL.DISTRICT_CODE as CODE,
  (select DISTRICT_NAME FROM DISTRICT WHERE DISTRICT_CODE = LOCATION_TBL.DISTRICT_CODE) 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
order by  (LOCATION_TBL.LATITUDE - base.LATITUDE) * (LOCATION_TBL.LATITUDE - base.LATITUDE) + 
   (LOCATION_TBL.LONGITUDE - base.LONGITUDE) * (LOCATION_TBL.LONGITUDE - base.LONGITUDE) desc,
 LOCATION_TBL.DISTRICT_CODE  
;