select 
L.DISTRICT_CODE as CODE
,DISTRICT_NAME as NAME
,LATITUDE as LAT
,LONGITUDE as LON
from 
LOCATION_TBL L,
(select LATITUDE as LAT11,LONGITUDE  as LON11 from LOCATION_TBL where DISTRICT_CODE = '1101' ) A11
left join DISTRICT D ON L.DISTRICT_CODE = D.DISTRICT_CODE

where L.DISTRICT_CODE <> '1101' 
order by 
SQRT(abs(LAT-LAT11)*abs(LAT-LAT11)+abs(LON-LON11)*abs(LON-LON11)) desc
,L.DISTRICT_CODE asc