ORACLE中取一个表的第100行到110行改怎么取

oracle 中采用rownum实现

select *

from (select t.*, rownum as row_num from 表名 t) tt

where tt.row_num between 100 and 110

select top 100 * from (select top 500 * from T1 order by id asc) a order by id desc

先asc取前500条 再倒着取(desc)这个结果的100条...

MSSQL在我这里测试通过

= =这个是否效率最高 俺就不得而知了 期待高人来探讨哈~

---