摘要：
今天闲来无事，测试了一下用Sql分页语句，从网上找了一些数据，总结Sql分页分为5种：--写法1，not in/topselect top 50 * from pagetest where id not in (select top 9900 id from pagetest order by id)order by id--写法2，not existsselect top 50 * from pagetest where not exists (select 1 from (select top 9900 id from pagetest order by id)a where a.id=. 阅读全文
