WITH T1 AS (
SELECT LOC.DISTRICT_CODE CODE,LOC.LATITUDE LAT,LOC.LONGITUDE LON,LOC2.LATITUDE LAT2,LOC2.LONGITUDE LON2,
(LOC2.LATITUDE-LOC.LATITUDE)*(LOC2.LATITUDE-LOC.LATITUDE)+(LOC2.LONGITUDE-LOC.LONGITUDE)*(LOC2.LONGITUDE-LOC.LONGITUDE) AS DISTANCE
FROM LOCATION_TBL AS LOC INNER JOIN LOCATION_TBL AS LOC2 ON LOC.PF_CODE=LOC2.PF_CODE AND LOC2.DISTRICT_CODE='1101'
WHERE LOC.DISTRICT_CODE<>'1101'
)
SELECT DS.DISTRICT_CODE CODE,DS.DISTRICT_NAME NAME,T1.LAT,T1.LON
FROM T1 INNER JOIN DISTRICT AS DS ON DS.DISTRICT_CODE=T1.CODE
ORDER BY DISTANCE