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