是的,您可以使用dense_rank
并避免重复的代码:
select col
from (select col, dense_rank() over (order by col) rnk from tbl)
where rnk <= 3
Oracle中一列的前n个不同值
是的,您可以使用dense_rank
并避免重复的代码:
select col
from (select col, dense_rank() over (order by col) rnk from tbl)
where rnk <= 3