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