文件名称：sql server 分页
文件大小：544B
文件格式：TXT
更新时间：2021-01-17 07:25:38
sql server 分页
sql server分页代码 --分页【top】:不支持复合主键 SELECT TOP 10 * from Lend where id not in (SELECT TOP ((2-1)*10) id from lend ORDER BY id) ORDER BY id ; SELECT TOP 10 * from Lend where id not in (SELECT TOP 10 id from lend ORDER BY id) ; SELECT * FROM Nect; --分页【max】:不支持非唯一列排序 select top 10 * from table1 where id>(select max(id) from (select top 开始位置 id from table1 order by id)tt) SELECT TOP 10 * from Lend WHERE id> (SELECT MAX(id) FROM (SELECT top 10 id FROM Lend ORDER BY id) M)