sql含有自动增长列时的分页语句

来源:互联网 发布:大数据大并发性能测试 编辑:程序博客网 时间:2024/05/21 11:17

 SELECT TOP 10 *
FROM jobs
WHERE (job_id NOT IN
          (SELECT TOP 10 job_id
         FROM jobs
         ORDER BY job_id))
ORDER BY job_id