数据库分页

Oracle: 

 

SELECT x.*

FROM (SELECT z.*,rownum rn  FROM table1 z WHERE rownum<100) x

WHERE x.rn>90

 

SqlServer:

 

select top 10 * form table1 where 范围  

 

MySql:

 

select * from table1 where ....... limit 0,100