SELECT 
 l.DISTRICT_CODE as CODE
 ,DISTRICT_NAME as NAME
 ,LATITUDE as LAT
 ,LONGITUDE as LON
FROM LOCATION_TBL l
 inner join DISTRICT d on d.DISTRICT_CODE = l.DISTRICT_CODE
where 
 CODE <> '1101'
ORDER BY 
   pow((select LATITUDE FROM LOCATION_TBL where DISTRICT_CODE = '1101') - LATITUDE,2) + (pow((select LONGITUDE FROM LOCATION_TBL where DISTRICT_CODE = '1101') - LONGITUDE,2)) desc
 ,CODE asc;