????????ROWNUM???????????????????????д???????????κβ???????
????SELECT * FROM ENT_ROLE WHERE ROWNUM > 10;
????SELECT * FROM ENT_ROLE WHERE ROWNUM >= 10;
???????Oracle???????????
????--Oracle??????
????SELECT
????*
????FROM
????(
????SELECT
????ROWNUM R??YANGCQ_ID??YANGCQ_BRANCHID
????FROM
????YANGCQ_USER
????WHERE
????ROWNUM <= 10
????)
????WHERE
????R > 5;
???????????????????????????ROWNUM ?????????????R??????????????R?У?????????????????У????????е??????
????????????????????????????
????SELECT
????*
????FROM
????(
????SELECT
????ROWNUM R??YANGCQ_ID??YANGCQ_BRANCHID
????FROM
????YANGCQ_USER
????)
????WHERE
????R > 5 AND
????R <= 10;