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,
pow(LATITUDE- tmp.LAT ,2)  LAT,
pow(LONGITUDE- tmp.LON ,2)  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  CODE,
 NAME,
LAT,LON
from tmp2 order by sqrt(LAT+LON) desc