select 
L.DISTRICT_CODE as CODE
,DISTRICT_NAME as NAME
,LATITUDE as LAT
,LONGITUDE as LON
--,abs(LATITUDE-LAT11)+abs(LONGITUDE-LON11)
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 
abs(LAT-LAT11)+abs(LON-LON11) desc
,L.DISTRICT_CODE asc