摘要: 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 阅读全文
posted @ 2011-03-15 21:06 灵雨飘零 阅读(300) 评论(0) 推荐(0) 编辑