with P1101 as(
    select * from LOCATION_TBL
    where DISTRICT_CODE  = '1101'
)
select 
LOCATION_TBL.DISTRICT_CODE as "CODE",
DISTRICT_NAME as  "NAME",
LOCATION_TBL.LATITUDE as "LAT",
LOCATION_TBL.LONGITUDE as "LON"
from LOCATION_TBL
inner join DISTRICT on LOCATION_TBL.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
inner join P1101 on 1
where LOCATION_TBL.DISTRICT_CODE  <> '1101'
order by 
SQRT(power(abs(LOCATION_TBL.LATITUDE- P1101.LATITUDE),2) +  power(abs(LOCATION_TBL.LONGITUDE- P1101.LONGITUDE),2)) desc
,LOCATION_TBL.DISTRICT_CODE asc