Aladdin

摘要： 过程一：select top N条记录 * from 文章表 where id not in(select top M条记录 id from 文章表 order by id desc ) order by id desc过程二：select top N条记录 * from 文章表 where id <(select min(id) from (select top M条记录 id from 文章表 order by id desc ) as tblTmp) order by id desc--简单通用CREATE PROCEDURE [dbo].[PageView] @select VA 阅读全文