SQLserver分页思考

select top 5 * from (select top 10 * from login) b
where b.logid>5

select * from login where logid>5 and logid <10


select top 5 * from jobs where (
job_id not in(select top 10 job_id from jobs order by job_id desc))

order by job_id


SELECT TOP 5 *

FROM jobs

WHERE (job_id <
(SELECT MAX(job_id)
FROM (SELECT TOP 10 job_id
FROM jobs
ORDER BY job_id) AS T))
ORDER BY job_id