[置顶] Sql Server分页分段查询百万级数据四种项目实例

SELECT TOP 50 * FROM infoTab WHERE ID NOT IN(SELECT TOP 100000 ID FROM infoTab)SELECT TOP 50 * FROM infoTab WHERE ID NOT IN(SELEC