摘要： 1.SELECT TOP 页大小 * FROM table WHERE 主键 NOT IN( SELECT TOP (页码-1)*页大小 主键 FROM table WHERE 查询条件 ORDER BY 排序条件)ORDER BY 排序条件 SELECT TOP 10* FROM HumanResources.Employee WHERE BusinessEntityID NOT IN (SELECT top 10 BusinessEntityID FROM HumanResources.Employee)按着上面的模板写个示例,发现，子查询中会返回10行数据，而主查询会返回所以得数... 阅读全文