摘要:
最快的方法: 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.. 阅读全文