with A as (
    select
        LATITUDE la,
        LONGITUDE lo
    from
        LOCATION_TBL
    where
        DISTRICT_CODE = '1101'
)
select
    X.DISTRICT_CODE CODE,
    DISTRICT_NAME NAME,
    LATITUDE LAT,
    LONGITUDE LON
from
    LOCATION_TBL X,
    A
    join DISTRICT dis on  x.DISTRICT_CODE = dis.DISTRICT_CODE
where
    x.DISTRICT_CODE <> '1101'
order by 
    (LATITUDE -a.la)*(LATITUDE -a.la)+(LONGITUDE-lo)*(LONGITUDE-lo) desc,
    1