WITH t AS (
  SELECT L.DISTRICT_CODE
        ,L.LATITUDE
        ,L.LONGITUDE
        ,acos(
         cos(radians(D.LATITUDE) ) * cos( radians( L.LATITUDE ) ) * cos( radians( L.LONGITUDE ) - radians(D.LONGITUDE) )
          + 
         sin( radians(D.LATITUDE) ) * sin( radians( L.LATITUDE ) ) ) 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