SQL> select SUBSCRIBERKEY from cbe_subscriber where rownum between 1 and 2;
SUBSCRIBERKEY
-------------
1
2
SQL> select SUBSCRIBERKEY from cbe_subscriber where rownum between 2 and 3;
no rows selected
SQL> select SUBSCRIBERKEY from (select rownum rn,SUBSCRIBERKEY from cbe_subscriber) where rn between 2 and 3;
SUBSCRIBERKEY
-------------
2
3
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22492385/viewspace-742838/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
分页查询
下一篇：
Oracle分页查询语句（一）
请登录后发表评论
登录
全部评论
