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
sql含有自动增长列时的分页语句
最新推荐文章于 2024-10-14 17:36:50 发布
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