三种分页语句

--------------------------------------------------------
--------------查询一张表第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