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