with tmp as (
SELECT 
loc.DISTRICT_CODE  CODE,
DISTRICT_NAME  NAME,
LATITUDE  LAT,
LONGITUDE  LON
FROM
LOCATION_TBL loc inner join DISTRICT dis on loc.district_code=dis.district_code
where loc.DISTRICT_CODE='1101'
),
tmp2 as (
SELECT 
loc.DISTRICT_CODE  CODE,
DISTRICT_NAME  NAME,
abs(LATITUDE- tmp.LAT )  LAT,
abs(LONGITUDE- tmp.LON )  LON
FROM
LOCATION_TBL loc inner join DISTRICT dis on loc.district_code=dis.district_code
 inner join tmp
where loc.DISTRICT_CODE <> '1101'
)
select  loc.DISTRICT_CODE CODE,
 NAME,
loc.LATITUDE LAT,loc.LONGITUDE LON
from tmp2 inner join 
LOCATION_TBL loc on loc.district_code=tmp2.code

order by sqrt(POW(tmp2.LAT,2)+POW(tmp2.LON,2)) desc,1 asc