方案一:利用NOT IN和SELECT TOP分页语句形式 SELECT TOP 10 * FROM TestTable WHERE ID NOT IN (SELECT TOP 20 ID FROM TestTable ORDER BY ID)