Shulou(Shulou.com)06/01 Report--

Paging is used in the project. Let's talk about the method of oracle paging.

Using pseudo column rownum

Query the first 10 records

[sql] select * from t_user t where ROWNUM (values greater than 1), > = (values greater than or equal to 1), = (values greater than or equal to 1), otherwise there is no result-- so direct use can only start from 1-- rownum > 10 is not recorded, because if the first item is not satisfied to be removed, the rownum of the second article becomes 1, so there is never a record that meets the conditions. Select * from student where rownum > = 1 select-if you want to use rownum without starting with 1, use the following method: select a1.* from (select student.*,rownum rn from student) A1 where rn > 5 select Mutual-paging query one select * from (select a1.handwriting rownum rn from (select * from student) A1 where rownum = 2Thirty-two select a1.* from (select student.*,rownum rn from student where rownum = 3) Paged query 3 select a1.* from (select student.*,rownum rn from student) A1 where rn between 3 and 5

The above is the centralized method of Oracle database pagination introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.