摘要： SQL分页有三种常用方法，按效率从高到低：1.效率最高SELECT TOP(分页记录数) *FROM 表名WHERE ID> ( SELECT ISNULL(MAX(ID),0) FROM ( SELECT TOP(分页记录数*(页码-1)) ID FROM 表名 ORDER BY ID ) A )ORDER BY ID2.效率次之SELECT top(分页数) * FROM 表名 where ID not in (... 阅读全文