with BasePoint AS
(SELECT Latitude, Longitude  FROM Location_TBL where District_Code = '1101' ),

 Distance AS
(
  select
    L.District_Code
   ,sqrt(POW(L.Latitude-B.Latitude , 2) + POW(L.Longitude-B.Longitude, 2))  dist 
   from Location_TBL L, BasePoint B
  where L.District_Code <> '1101'
  order by dist
)

select
     L.District_Code CODE
    ,D.District_Name NAME
    ,L.Latitude LAT
    ,L.Longitude LON
from
    Location_TBL L
inner join
    District D
ON
    L.District_Code = D.District_Code
inner join
    Distance Dist
ON
    L.District_Code = Dist.District_Code
ORDER BY
     Dist.Dist DESC
    ,L.District_Code 
;