SELECT CODE, NAME, LAT, LON
FROM 
(SELECT
  LOCATION_TBL.DISTRICT_CODE AS CODE,
  DISTRICT.DISTRICT_NAME AS NAME,
  LOCATION_TBL.LATITUDE AS LAT,
  LOCATION_TBL.LONGITUDE AS LON,
  SQRT(POW(ABS((SELECT LATITUDE AS LAT1 FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101')-LOCATION_TBL.LATITUDE),2)+POW(ABS((SELECT LONGITUDE AS LON1 FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101')-LOCATION_TBL.LONGITUDE),2)) DISTANCE
FROM LOCATION_TBL LEFT OUTER JOIN DISTRICT
ON LOCATION_TBL.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
WHERE LOCATION_TBL.DISTRICT_CODE <> '1101')
ORDER BY DISTANCE DESC,CODE