WITH A AS (
    SELECT *
    FROM LOCATION_TBL
    WHERE DISTRICT_CODE = '1101'
), temp AS (
    SELECT 
        t1.*
        , POW(t1.LATITUDE - A.LATITUDE, 2) 
            + POW(t1.LONGITUDE  - A.LONGITUDE , 2) AS distance
    FROM LOCATION_TBL AS t1 CROSS JOIN A
)

SELECT
    DISTRICT_CODE AS CODE
    , DISTRICT_NAME AS NAME
    , LATITUDE AS LAT
    , LONGITUDE AS LON
FROM temp INNER JOIN DISTRICT USING(DISTRICT_CODE)
ORDER BY distance DESC, 1