select 
    l.DISTRICT_CODE as CODE,
    d.DISTRICT_NAME as NAME,
    l.LATITUDE as LAT,
    l.LONGITUDE as LON
from
    LOCATION_TBL l
left join
    DISTRICT d
on
    l.DISTRICT_CODE = d.DISTRICT_CODE
where
    l.DISTRICT_CODE != '1101'
order by
    power(LATITUDE - (select LATITUDE from LOCATION_TBL where l.DISTRICT_CODE = '1101'),2)
    +power(LONGITUDE - (select LONGITUDE from LOCATION_TBL where l.DISTRICT_CODE = '1101'),2) desc,
    l.DISTRICT_CODE asc