摘要:
SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM <= 40 ) WHERE RN >= 21 select e.*,rownum from emp e order by sal; 阅读全文
摘要:
create table t1( id number(10), name varchar2(10));create table t2( id number(10), name varchar2(10)); insert into t1 values(1,'06');insert into t1 va 阅读全文