三種分頁語句

-------------------------------------------------------- --------------查詢一張表第15行到30行資料-------------- --方法1 select top 10 * from jobs where job_id not in (select top 5 job_id from jobs) --方法2 select * from (select top 15 * from jobs where job_id  in  (select top 30 job_id  from jobs t ) order by Job_id desc )  tt order by Job_id --方法3 select top 15 * from  jobs where Job_id >  (select Max(job_id)  from  ( select top 15 *  from jobs  ) t ) --方法4 select top 15 * from  (select top 30 job_id  from jobs  )t  order by Job_id desc