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

The paging query statement of Oracle can basically be applied according to the format given in this article.

Paging query format:

SELECT * FROM

(

SELECT A.V., ROWNUM RN

FROM (SELECT * FROM TABLE_NAME) A

WHERE ROWNUM = 21

The innermost query SELECT * FROM TABLE_NAME represents the original query statement that does not turn the page. ROWNUM = 21 controls the scope of each page of the paging query.

The paging query given above is efficient in most cases. The purpose of paging is to control the size of the output result set and return the results as soon as possible. In the paging query above, this consideration is mainly reflected in WHERE ROWNUM

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.