现有表A 查询从第10行之后的数据
select a from ( select a, rownum r from A ) where r > 10 order by r;
实际工作中例子
select account,acct_name from ( select account, acct_name, rownum r from pmctl_nonsleep_acct ) where r >= 10 order by
现有表A 查询从第10行之后的数据
select a from ( select a, rownum r from A ) where r > 10 order by r;
实际工作中例子
select account,acct_name from ( select account, acct_name, rownum r from pmctl_nonsleep_acct ) where r >= 10 order by