select 
    T.DISTRICT_CODE as CODE
    , ( select DISTRICT_NAME from DISTRICT where DISTRICT.DISTRICT_CODE = T.DISTRICT_CODE ) as NAME
    , T.LATITUDE as LAT
    , T.LONGITUDE as LON
 from LOCATION_TBL as T
 cross JOIN LOCATION_TBL as LT on LT.DISTRICT_CODE = '1101' 
 where T.DISTRICT_CODE <> '1101'
 order by POW( ABS(T.LATITUDE - LT.LATITUDE), 2) + POW((T.LONGITUDE - LT.LONGITUDE), 2)  desc , T.DISTRICT_CODE