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