select f1, f2, f3 from
(select f1,f2, f3, row_number() over(partition by f1 order by f2)rnum
from (select f1, f2, f3 from tab_name ))
where rnum = 1;
816及以上版本适用
select f1, f2, f3 from
(select f1,f2, f3, row_number() over(partition by f1 order by f2)rnum
from (select f1, f2, f3 from tab_name ))
where rnum = 1;
816及以上版本适用