1. select * from 表1 where rownum<=10; 2. select * from 表2 where rownum<=10 roder by desc;
1. select * from 表1 where rownum<=10;2, 以emp表为例: create or replace function getNo return varchar2 is vEmpNo varchar2(20); iLoop number; BEGIN select max(empno) into vEmpNo from emp; for iLoop in 1..10 loop select max(empno) into vEmpNo from emp where empno < vEmpNo; end loop; return vEmpNo; END; /select empno,ename from emp where empno > getNo;
2. select * from 表2 where rownum<=10 roder by desc;
create or replace function getNo
return varchar2 is
vEmpNo varchar2(20);
iLoop number;
BEGIN
select max(empno) into vEmpNo from emp; for iLoop in 1..10 loop
select max(empno) into vEmpNo from emp where empno < vEmpNo;
end loop; return vEmpNo;
END;
/select empno,ename from emp where empno > getNo;