A small problem with Oracle's paging query

Order form. Same Order ID as order Information table (multiple order information columns)

Find out all orders and their information and page them according to the order

SELECT * FROM (Select a. *, (Dense_rank () over (order by ID DESC)) as Numindex from (select O. *, Dense_rank () over (order B Y o.id DESC) as RN from Order O) a where RN <=) where Numindex > 0

Find out all orders and their information and page them according to the order information

SELECT * FROM (select A.*, ROWNUM RN from (SELECT * from Order o left  joins OrderDetail od on O.id=od.orderid) A wher E ROWNUM <=) WHERE RN >= 0

Rank () Over,dense_rank (), row_number () difference

Rank () Over is the function of identifying the specified conditions after a ranking, but there is a feature. If it is to the student rankings. Then this function is useful. The same two grades are tied up. The proportions are as follows 1 2 2 4.

Picindex=1 "target=" _self "style=" position:relative; Display:block; Float:left ">

Dense_rank () The Role and rank () very much like, the only difference is that brought life students in the results of the tie, the next classmate does not empty the rank of the position, than for example, 1 2 2 3.

Row_number () is different, and the difference between it and the above two is very obvious. This function does not need to consider whether or not to tie, even if the value of the query based on the values will also be ranked consecutively, for example,

Rank () Over,dense_rank (), row_number () The use of the method specifically explained Http://www.cnblogs.com/wuyisky/archive/2010/02/24/oracle_rank.html

A small problem with Oracle's paging query