select DI.DISTRICT_CODE CODE
     , DISTRICT_NAME NAME
     , LATITUDE      LAT
     , LONGITUDE     LON

from DISTRICT DI
     inner join LOCATION_TBL LO on DI.DISTRICT_CODE = LO.DISTRICT_CODE
     ,(select LATITUDE  la1
                      , LONGITUDE lo2
                 from LOCATION_TBL
                 where DISTRICT_CODE = '1101'
                 limit 1) X
where DI.DISTRICT_CODE <> '1101'
order by

    (X.la1-LATITUDE)*(X.la1-LATITUDE)+
    (X.lo2-LONGITUDE)*(X.lo2-LONGITUDE) desc,1