with t as (
    select latitude as l0, longitude as l1 from LOCATION_TBL where DISTRICT_CODE='1101'
) 
-- select * from t
select district_code as CODE,
district_name as NAME,
latitude as LAT,
longitude as LON
from (
    select * from LOCATION_TBL as l
    inner join DISTRICT as d on d.DISTRICT_CODE=l.DISTRICT_CODE
    cross join t
    where l.district_code!='1101'
) as z
order by (latitude-l0)*(latitude-l0)+(longitude-l1)*(longitude-l1) desc,1