SELECT
 t2.DISTRICT_CODE AS CODE
,t2.DISTRICT_NAME AS NAME
,t2.LATITUDE AS LAT
,t2.LONGITUDE AS LON
FROM
(
SELECT
PF_CODE
,LATITUDE
,LONGITUDE
FROM
LOCATION_TBL
WHERE
DISTRICT_CODE = '1101'
) t1
,(
SELECT *
FROM
 LOCATION_TBL tm1
,DISTRICT tm2
WHERE
tm1.PF_CODE = tm2.PF_CODE
AND tm1.DISTRICT_CODE = tm2.DISTRICT_CODE
AND tm1.DISTRICT_CODE <> '1101'
) t2
ORDER BY
abs(t1.LATITUDE - t2.LATITUDE) + abs(t1.LONGITUDE - t2.LONGITUDE) DESC
,t2.DISTRICT_CODE