数据库取出制定数据的语句操作

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