从第n条记录开始查询第Ｍ条记录

//一般这样效率是很低的。
SELECT TOP 5 *
FROM admin
WHERE (id NOT IN
          (SELECT TOP 5 admin.id
         FROM admin
         ORDER BY id DESC))
ORDER BY id DESC

 

//效率高
select top M *
from table
where id> (select max(id) from (select top N id from table order by id) a)
order by id