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

原创于 2016-11-17 12:01:30 发布 · 505 阅读

·

0

·

0 ·

本内容遵循CC 4.0 BY-SA版权协议

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