用
id
排序 之后在用rowid取出 31 - 40 条记录。
select * from (select A.*,a.rowid from A order by id asc) where rowid>30 and rowid< 41
SQL语句为: select * from A where ID >=31 and ID <= 40 ORACLE语句为: select * from A where RowNum>=31 and RowNum<=40 ORACLE和SQL都能使用的是 select top 10 * from (select top 40 * from A order by ID) order by ID desc 或者是 select top 10 * from A where ID not in (select ID from top 30 from A)