with 
tbl1 as(
select
LATITUDE as T_LAT
,LONGITUDE as T_LON
from LOCATION_TBL
where DISTRICT_CODE=1101
)
select 
LT.DISTRICT_CODE as CODE
,DI.DISTRICT_NAME as NAME
,LT.LATITUDE as LAT
,LT.LONGITUDE as LON
from LOCATION_TBL LT
    inner join DISTRICT DI on LT.DISTRICT_CODE=DI.DISTRICT_CODE
    cross join tbl1
where LT.DISTRICT_CODE !=1101
order by power(LAT-T_LAT,2)+power(LON-T_LON,2)  desc, LT.DISTRICT_CODE asc