select
  location.DISTRICT_CODE as "CODE"
  ,DISTRICT_NAME as "NAME"
  ,location.LATITUDE as LAT
  ,location.LONGITUDE as LON
--  ,pow(center.LATITUDE - location.LATITUDE, 2) + pow(center.LONGITUDE - location.LONGITUDE, 2)
from
  LOCATION_TBL as location
join
  DISTRICT
on
  location.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
join
  LOCATION_TBL as center
on
  center.DISTRICT_CODE = '1101'
where
  location.PF_CODE = '01000'
  and location.DISTRICT_CODE <> '1101'
order by
  pow(center.LATITUDE - location.LATITUDE, 2) + pow(center.LONGITUDE - location.LONGITUDE, 2) desc
  , location.DISTRICT_CODE