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