SELECT tt.f_1, tt.f_2, tt.f_3
  FROM (SELECT f_1, f_2, f_3, MAX (f_3) OVER (PARTITION BY f_1) AS ms
          FROM ags_tmp) tt
 WHERE tt.f_3 = tt.ms

SELECT tmp.f_1, tmp.f_2, tmp.f_3
  FROM ags_tmp tmp,
       (SELECT   f_1, MAX (f_3) AS ms
            FROM ags_tmp
        GROUP BY f_1) t
 WHERE tmp.f_3 = t.ms