WITH BASE AS (
SELECT LATITUDE,LONGITUDE
  FROM LOCATION_TBL
 WHERE DISTRICT_CODE = '1101'
)
SELECT LT.DISTRICT_CODE AS CODE,
       D.DISTRICT_NAME AS NAME,
       LT.LATITUDE AS LAT,
       LT.LONGITUDE AS LON
  FROM LOCATION_TBL LT LEFT JOIN DISTRICT D
                         ON LT.DISTRICT_CODE = D.DISTRICT_CODE,BASE
 WHERE LT.DISTRICT_CODE <> '1101'
 ORDER BY SQRT((POW((LT.LATITUDE - BASE.LATITUDE),2)) + (POW((LT.LONGITUDE - BASE.LONGITUDE),2))) DESC,CODE ASC