SQL分页实现

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