本文共 1378 字，大约阅读时间需要 4 分钟。

Oracle ????? rownum ? rowid ?????????????????????????????????????

1. rownum ???

rownum ? Oracle ??????????????????????????????rownum ??? 1 ???????????????

rownum ?????

rownum ????????????????????????????

select rownum, phone_no from ur_user_info where rownum < 6;

??????? ur_user_info ??? 5 ??????? rownum < 6 ?? rownum = 1 ? rownum = 5??

rownum ?????

???????rownum ?????????????????????????????? rownum ?????????

select rownum, phone_no from (select rownum rn, phone_no from ur_user_info) a where a.rownum > 5 and a.rownum < 10;

?????????????

select rownum, * from (select rownum rn, a.* from ur_user_info a where rownum < 10) a where a.rn > 5;

??? rownum ?????????????????????

2. rowid ???

rowid ? Oracle ?????????????????? ROWID ???????????OID??rowid ???? 10 ? 16 ??????????????

rowid ?????

rowid ?????????????????????????

select rowid, phone_no from ur_user_info where rowid > 5 and rowid < 10;

??????? ur_user_info ?? rowid ? 6 ? 9 ????????

rowid ?????

???????rowid ???????????????????????????????????

delete from bal_acctbook_info where rowid not in (select min(rowid) from bal_acctbook_info where balance_id = '4012562452' and op_time = '20171212111111');

??? rowid ??????????????????????????

????

• rownum ? rowid ??????? rownum ??????????? rowid ????????????
• ??? rownum ?????????????????????
• rowid ????? joins ???????????????????

???????rownum ? rowid ???????????????????