sql server 分页

sqlserver分页代码--分页【top】:不支持复合主键SELECTTOP10*fromLendwhereidnotin(SELECTTOP((2-1)*10)idfromlendORDERBYid)ORDERBYid;SELECTTOP10*fromLendwhereidnotin(SELECTTOP10idfromlendORDERBYid);SELECT*FROMNect;--分页【max】:不支持非唯一列排序selecttop10*fromtable1whereid>(selec