WITH BASE 
AS  (
    SELECT  LATITUDE, LONGITUDE
    FROM    LOCATION_TBL
    WHERE   DISTRICt_CODE = '1101'
    )
SELECT  lt.DISTRICT_CODE AS CODE,
        DISTRICT_NAME AS NAME,
        LATITUDE AS LAT,
        LONGITUDE AS LON
FROM    LOCATION_TBL AS lt
JOIN    DISTRICT AS d
ON      lt.DISTRICT_CODE = d.DISTRICT_CODE
ORDER BY sqrt(
            POW(((SELECT LATITUDE FROM BASE) - lt.LATITUDE), 2) +
            POW(((SELECT LONGITUDE FROM BASE) - lt.LONGITUDE), 2)
) DESC, lt.DISTRICT_CODE