select LA.DISTRICT_CODE CODE
, D.DISTRICT_NAME NAME
, LA.LATITUDE LAT
, LA.LONGITUDE LON
--, sqrt(
--      (LA.LATITUDE - LB.LATITUDE) * (LA.LATITUDE - LB.LATITUDE)
--      + (LA.LONGITUDE - LB.LONGITUDE) * (LA.LONGITUDE - LB.LONGITUDE)
--      )
from LOCATION_TBL LA
     inner join DISTRICT D
       ON D.DISTRICT_CODE = LA.DISTRICT_CODE
     cross join (select L2.* from LOCATION_TBL L2
                 where L2.DISTRICT_CODE = '1101') LB
where LA.DISTRICT_CODE <> '1101'
order by 
 sqrt((LA.LATITUDE - LB.LATITUDE) * (LA.LATITUDE - LB.LATITUDE)
      + (LA.LONGITUDE - LB.LONGITUDE) * (LA.LONGITUDE - LB.LONGITUDE)
      ) desc
, LA.DISTRICT_CODE
;