SELECT A.DISTRICT_CODE AS CODE,
B.DISTRICT_NAME AS NAME,
A.LATITUDE AS LAT,
A.LONGITUDE AS LON
FROM  LOCATION_TBL A
INNER JOIN DISTRICT B
 ON A.DISTRICT_CODE = B.DISTRICT_CODE,
(SELECT
 LATITUDE AS B_LATITUDE,
 LONGITUDE AS B_LONGITUDE 
FROM  LOCATION_TBL
WHERE DISTRICT_CODE ='1101') C
WHERE A.DISTRICT_CODE != '1101'
ORDER BY POW(A.LATITUDE-C.B_LATITUDE,2) + POW(A.LONGITUDE-C.B_LONGITUDE,2) DESC
,A.DISTRICT_CODE