摘要： [转载]取n到m条记录的语句(1). select top m * from tablename where id not in (select top n id from tablename) 结果：从第n条记录开始，顺序取m条记录 (2). select top m * into #a from tablename order by id -- 将top m笔插入 set rowcount n `````````-- 设置固定显示的记录数 select * from #a order by id desc -- 先倒序，再取3条记录 结果：从... 阅读全文