SELECT
    lo.DISTRICT_CODE AS CODE
    ,di.DISTRICT_NAME AS NAME
    ,lo.LATITUDE AS LAT
    ,lo.LONGITUDE AS LON
FROM
    LOCATION_TBL lo
CROSS JOIN (
    SELECT
        LATITUDE
        ,LONGITUDE
    FROM LOCATION_TBL
    WHERE DISTRICT_CODE = '1101'
) tmp
INNER JOIN DISTRICT di
    ON lo.DISTRICT_CODE = di.DISTRICT_CODE
WHERE
    lo.DISTRICT_CODE != '1101'
ORDER BY
    POW((lo.LATITUDE - tmp.LATITUDE), 2) + POW((lo.LONGITUDE - tmp.LONGITUDE), 2) DESC
    ,lo.DISTRICT_CODE;