SELECT 
r.DISTRICT_CODE AS CODE,
r.DISTRICT_NAME AS NAME,
r.LATITUDE AS LAT,
r.LONGITUDE AS LON
FROM
(
SELECT 
    a.DISTRICT_CODE,
    d.DISTRICT_NAME,
    a.LATITUDE,
    a.LONGITUDE,
    sqrt(pow(abs(a.LATITUDE - b.LATITUDE),2) + pow(abs(a.LONGITUDE - b.LONGITUDE),2) ) AS DIST
     FROM LOCATION_TBL a
     INNER JOIN DISTRICT d
     ON d.DISTRICT_CODE = a.DISTRICT_CODE
     LEFT OUTER JOIN LOCATION_TBL b
     ON b.DISTRICT_CODE = '1101'
     WHERE a.DISTRICT_CODE != '1101'
) r
ORDER BY r.DIST DESC, r.DISTRICT_CODE ASC;