select 
t1.DISTRICT_CODE as CODE,
t1.DISTRICT_NAME as NAME,
t2.LATITUDE as LAT,
t2.LONGITUDE as LON
from DISTRICT t1
inner join  LOCATION_TBL t2
on t1.DISTRICT_CODE=t2.DISTRICT_CODE
where t1.DISTRICT_CODE!=1101
order by 
sqrt(pow((t2.LATITUDE-(select LATITUDE from LOCATION_TBL where DISTRICT_CODE=1101)),2)+pow((t2.LONGITUDE-(select LONGITUDE from LOCATION_TBL where DISTRICT_CODE=1101)),2)) desc
,t1.DISTRICT_CODE