select 
a.district_code as code
,b.district_name as name
,a.latitude as lat
,a.longitude as lon
from 
(
    select 
    pf_code
    ,district_code
    ,latitude
    ,longitude
    ,(select latitude from location_tbl where district_code='1101' ) as latitude_1101
    ,(select longitude from location_tbl where district_code='1101' ) as longitude_1101
    from location_tbl
    where district_code!='1101'
)a
inner join district b on a.district_code = b.district_code
order by
sqrt(pow(latitude-latitude_1101,2)+pow(longitude-longitude_1101,2)) desc
,a.district_code