with TBL as (
    select * from LOCATION_TBL
    where DISTRICT_CODE  = '1101'
    )
select 
  c.DISTRICT_CODE as CODE
  ,e.DISTRICT_NAME as NAME
  , c.LATITUDE as LAT
  , c.LONGITUDE as LON
from 
    LOCATION_TBL c
inner join 
    (
        select
          a.*
          ,sqrt(pow(b.LATITUDE-a.LATITUDE,2) + pow(b.LONGITUDE-a.LONGITUDE,2)) as DISTANCE 
        from
            LOCATION_TBL a
        cross join TBL b
    ) d
    on c.PF_CODE = d.PF_CODE 
    and c.DISTRICT_CODE = d.DISTRICT_CODE 
inner join DISTRICT e
    on c.DISTRICT_CODE  = e.DISTRICT_CODE 
where c.DISTRICT_CODE  != '1101'
order by
    DISTANCE desc
    ,c.DISTRICT_CODE