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