Oracle 返回重复记录第一条

select f1, f2, f3 from (select f1,f2, f3, row_number() over(partition by f1 order by f2)rnumfrom (select f1, f2, f3 from tab_name ))where rnum = 1;

816及以上版本适用