select R_Num, R_Name, max(Results) as Results
   from tab
  group by Results, R_Name

select r_num, r_name, max(results)
from t
group by r_num, r_name;