WITH t AS (
  SELECT L.DISTRICT_CODE
        ,L.LATITUDE
        ,L.LONGITUDE
        ,abs((D.LATITUDE - L.LATITUDE) + (D.LONGITUDE - L.LONGITUDE)) AS DIST
    FROM LOCATION_TBL L
        , (SELECT LATITUDE
                 ,LONGITUDE
             FROM LOCATION_TBL
            WHERE DISTRICT_CODE = '1101'
          ) D 
    WHERE L.DISTRICT_CODE <> '1101'
)
SELECT
 t.DISTRICT_CODE AS CODE
,D.DISTRICT_NAME AS NAME
,t.LATITUDE AS LAT
,t.LONGITUDE AS LON
  FROM t
  INNER JOIN DISTRICT D
     ON t.DISTRICT_CODE = D.DISTRICT_CODE
 ORDER BY DIST DESC, t.DISTRICT_CODE