SQL Server 分页查询

最快的方法：

　　SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY E.EMPID ASC) AS ROWID, * FROM EMPLOYEE AS E) AS EM WHERE EM.ROWID BETWEEN 1 AND 10;

 

子查询方法（比上一个慢）：

SELECT * FROM 
(
　　SELECT TOP 30 * FROM (SELECT TOP 45030 * FROM ARTICLE ORDER BY YEAR DESC, ID DESC) f ORDER BY f.YEAR ASC, f.ID DESC
) s ORDER BY s.YEAR DESC,s.ID DESC  

可以参考http://www.cnblogs.com/ddlink/archive/2013/03/30/2991007.html