1、oracle
select * from (select t.*, rownum rn from (select * from t1 order by t1.cid desc) t where rownum < 100000) where rn > 99900;
t1为表名 cid为表的关键字段
2、MySQL
select * from t1 limit 10,20
t1为表名 ,limit函数
3、SQL server
top
1、oracle
select * from (select t.*, rownum rn from (select * from t1 order by t1.cid desc) t where rownum < 100000) where rn > 99900;
t1为表名 cid为表的关键字段
2、MySQL
select * from t1 limit 10,20
t1为表名 ,limit函数
3、SQL server
top