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 SQRT ( POW( LT.LATITUDE - T.LATITUDE, 2) + POW(LT.LONGITUDE - T.LONGITUDE, 2) ) desc , T.DISTRICT_CODE