Oracle rownum

1)查询第90到100条

 

SELECT * from (SELECT z.aac001,rownum numbers from ac01 z where rownum<101) x where x.numbers>90 ;

 

 

91

92

.

100

 

 

 

2).用分析函数吧 (10g)

select X.*  
from   
(  
    select   
        row_number() over(order by aac001) as ROW_NO,  
        ac01.*  
    from ac01
) X  
where X.ROW_NO <= 100  
    and X.ROW_NO >= 10;

 

3)