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
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