Select d.DISTRICT_CODE as CODE ,DISTRICT_NAME as NAME, LATITUDE as LAT,LONGITUDE as LON
From DISTRICT as d INNER JOIN 
LOCATION_TBL as l on d.DISTRICT_CODE=l.DISTRICT_CODE 

LEFT OUTER JOIN 
(select l1.DISTRICT_CODE as DIST, POW(abs(l1.LATITUDE-l2.LATITUDE),2)+POW(abs(l1.LONGITUDE-l2.LONGITUDE),2) as k
from LOCATION_TBL as l1 LEFT OUTER JOIN LOCATION_TBL as l2 on l2.DISTRICT_CODE = '1101' ) as lk on d.DISTRICT_CODE=lk.DIST
WHERE d.DISTRICT_CODE<>'1101'
ORDER BY lk.k DESC,CODE ASC;