We often have to access a middle part of the data set, such as the 10th to 20th records, and there is a good statement in Oracle to implement, that is,. The following is an example:
With partdata as (SELECT ROWNUM ROWNO, T. * from table1 t where t.id> 200407160000) Select * from partdata where riono betWeen 10 and 20
Of course, there is another way, but I am currently tested the fastest speed. The above code is tested in Oracle 9i
