举个例子:select r,e.* from (select rownum r,last_name,salary from ( select last_name,salary from employees order by nvl(salary,0) asc)) e where r <10;这里n=10,替换你的表名字和列名字即可
呵呵,写错了。ROWNUM<6,不好意思。
如 tgm78(shop34161266.taobao.com) 所说
update cc set ... where r in (select a.r from (select rownum r,cc.* from cc order by c01) a where a.r<=n)
就可以选择前5条数据
select last_name,salary from employees order by nvl(salary,0) asc)) e
where r <10;这里n=10,替换你的表名字和列名字即可