with len as (
  select 
    PF_CODE,
    DISTRICT_CODE,
    LATITUDE,
    LONGITUDE,
    sqrt((POW((select LATITUDE from LOCATION_TBL where DISTRICT_CODE = '1101') - LATITUDE, 2) + POW((select LONGITUDE from LOCATION_TBL where DISTRICT_CODE = '1101') - LONGITUDE, 2))) as length
  from LOCATION_TBL
)
select 
  d.DISTRICT_CODE as CODE,
  d.DISTRICT_NAME as NAME,
  LATITUDE as LAT,
  LONGITUDE as LON
from DISTRICT d
join len l on d.DISTRICT_CODE = l.DISTRICT_CODE
where length <> 0
order by length desc, CODE asc
;