SELECT 
L.DISTRICT_CODE AS CODE, 
DISTRICT_NAME AS NAME,
LATITUDE AS LAT,
LONGITUDE AS LON
FROM LOCATION_TBL AS L
JOIN DISTRICT AS P
ON L.DISTRICT_CODE = P.DISTRICT_CODE
WHERE CODE <> '1101'
ORDER BY
POW(
L.LATITUDE-
(SELECT LATITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101')
, 2)
+
POW(
L.LONGITUDE-
(SELECT LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101')
, 2)
DESC, CODE ASC