with tbl as( 
select
l.district_code as CODE
,district_name as NAME
,l.latitude as ALT
,l.LONGITUDE as LON
,abs(l.latitude - A.latitude)*abs(l.latitude - A.latitude)+abs(l.longitude - A.longitude)*abs(l.longitude - A.longitude)as l
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 desc,CODE)

select CODE,NAME,ALT,LON from tbl