select *
from (select t.*,rank() over(partition by t.字段名称1 order by t.字段名称2) rn
from t
)
where rn<= n
select *
from (select t.*,rank() over(partition by t.字段名称1 order by t.字段名称2) rn
from t
)
where rn<= n
本文标题:oracle中,每种类型的数据,各取n行(随意取)
本文链接:https://www.haomeiwen.com/subject/xwrdactx.html
网友评论