select 
  CODE
  , NAME
  , LAT
  , LON
from
  (
    select 
      LT.DISTRICT_CODE as CODE
      , DISTRICT_NAME as NAME
      , LATITUDE as LAT
      , LONGITUDE as LON
      , '1101' as TMP
    from
      LOCATION_TBL LT
      left join DISTRICT D
      on LT.DISTRICT_CODE = D.DISTRICT_CODE
    where 
      LT.DISTRICT_CODE <> '1101'
  ) as T1
  left join LOCATION_TBL T2
  on T1.TMP = T2.DISTRICT_CODE
order by 
  -- (T1.LON - T2.LONGITUDE) * (T1.LON - T2.LONGITUDE) + (T1.LAT - T2.LATITUDE) * (T1.LAT - T2.LATITUDE) desc
  -- sqrt((T1.LON - T2.LONGITUDE) * (T1.LON - T2.LONGITUDE) + (T1.LAT - T2.LATITUDE) * (T1.LAT - T2.LATITUDE)) desc
  sqrt(power(T2.LONGITUDE - T1.LON, 2) + power(T2.LATITUDE - T1.LAT, 2)) desc
  -- pow(T2.LONGITUDE - T1.LON, 2) + pow(T2.LATITUDE - T1.LAT, 2) desc
  , CODE
;