Three paging statements

-------------------------------------------------------- -------------- Query 15th to 30 rows of data in a table -------------- -- Method 1 Select top 10 * from jobs where job_id not in (select top 5 job_id from jobs) -- Method 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 -- Method 3 Select top 15 * from jobs where job_id> (Select max (job_id) from (select top 15 * from jobs) T) -- Method 4 Select top 15 * from (select top 30 job_id from jobs) T order by job_id DESC