摘要:
1.分页方案一:(利用Not In和SELECT TOP分页) 语句形式:SELECT TOP 10 *FROM TestTableWHERE (ID NOT IN(SELECT TOP 20 idFROM TestTableORDER BY id))ORDER BY IDSELECT TOP 页大小 *FROM TestTableWHERE (ID NOT IN(SELECT TOP 页大小*页数 idFROM 表ORDER BY id))ORDER BY ID2.分页方案二:(利用ID大于多少和SELECT TOP分页)语句形式:SELECT TOP 10 *FROM TestTableW 阅读全文