WITH TMP AS (
  SELECT 
    L.DISTRICT_CODE,
    L.LATITUDE,
    L.LONGITUDE,
    SQRT(POWER(L.LATITUDE - T.LATITUDE, 2) + POWER(L.LONGITUDE - T.LONGITUDE, 2)) AS DISTANCE
  FROM 
    LOCATION_TBL  AS L
  JOIN 
    LOCATION_TBL  AS T 
  ON 
    T.DISTRICT_CODE = '1101'
  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 
    TMP AS T
JOIN 
    DISTRICT AS D
ON 
    T.DISTRICT_CODE = D.DISTRICT_CODE
ORDER BY 
    DISTANCE DESC,
    D.DISTRICT_CODE ASC;