select
l.district_code as CODE
,district_name as NAME
,l.latitude as LAT
,l.LONGITUDE as LON
from location_tbl as l
inner join district as d
on l.district_code = d.district_code
cross join (
    select latitude,longitude from location_tbl where district_code ='1101'
) as A
where code <> '1101'
order by (l.latitude - A.latitude)*(l.latitude - A.latitude)+(l.longitude - A.longitude)*(l.longitude - A.longitude) desc,CODE