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 (POW((BASE.LATITUDE- LT.LATITUDE),2)) + (POW((BASE.LONGITUDE - LT.LONGITUDE),2)) DESC,CODE ASC