Oracle uses rownum and rowid for paging

For more information about rownum and rowid, see:

For details about how to use rownum paging, refer to the following SQL

Select*From (

 SelectT1.*, RownumRnFrom (

Select*FromScott.EmpOrder BySalDesc --Here is the sorted table

 )T1Where Rownum < 8 --Here is the upper limit

) WhereRn> 5 --Here is the lower limit

 

For more information about rowid paging, see the following SQL statement. rowid is more efficient than rownum.

Select*FromScott.EmpWhere Rowid In ( --Select the fields to be queried.

 SelectRidFrom (

Select RownumRn,RidFrom (

Select RowidRid,SalFromScott.EmpOrder BySalDesc --Sort tables here

) Where Rownum < 8 --Here is the upper limit

 ) WhereRn> 5 --Here is the lower limit

) Order BySalDesc --Sort again here

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12