摘要:
-- top 方式的查询方法-- pageSize:页面的容量-- pageNum:当前页面的编号 2select top 5 * from 表名 where id not in(select top 5 id from 表名) -- row_number 查询方法-- row_number() over()select row_number() over(order by id) as rum ,* from 表名select * from (select row_number() over(order by id) as rum ,* from 表名) as ttwhere rum> 阅读全文