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,
  POW(ABS((SELECT LATITUDE AS LAT1 FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101' AND PF_CODE = '01000')-LOCATION_TBL.LATITUDE),2)+POW(ABS((SELECT LONGITUDE AS LON1 FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101' AND PF_CODE = '01000')-LOCATION_TBL.LONGITUDE),2) DISTANCE
FROM LOCATION_TBL JOIN DISTRICT
ON LOCATION_TBL.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
WHERE LOCATION_TBL.DISTRICT_CODE <> '1101' AND PF_CODE = '01000')
ORDER BY DISTANCE DESC,CODE