SELECT
    LOC1.DISTRICT_CODE AS CODE,
    DISTRICT_NAME AS NAME,
    LOC1.LATITUDE AS LAT,
    LOC1.LONGITUDE AS LON
FROM LOCATION_TBL LOC1
CROSS JOIN (
    SELECT
        LATITUDE,
        LONGITUDE
    FROM LOCATION_TBL
    WHERE DISTRICT_CODE='1101'
    ) AS LOC2
    INNER JOIN DISTRICT AS DIS ON DIS.DISTRICT_CODE=LOC1.DISTRICT_CODE
WHERE LOC1.DISTRICT_CODE<>'1101'
ORDER BY (POW((LOC1.LATITUDE-LOC1.LONGITUDE),2)+POW((LOC2.LATITUDE-LOC2.LONGITUDE),2)) DESC,LOC1.DISTRICT_CODE