numbertable指表
numberid指列
select numberid from (select numberid from numbertable order by numberid)
where rownum <=5;
numberid指列
select numberid from (select numberid from numbertable order by numberid)
where rownum <=5;
from t)
where rk<=5
over(patition by col order by col)是什么意思呀,能不能解释一下
根据col分组并排序