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)