select *
from (select t.*, rownum rn
from (select * from c_order order by order_id) t --column
where rownum <= 8) --endindex
where rn >= 1 --beginindex
sqlserver
select top 8 * --结束位置
from org_staff
where id not in
(select top 5 id from org_staff order by id asc)--起始位置
order by id asc