SELECT *FROM ( SELECT 查询字段 , ROW_NUMBER() OVER ( ORDER BY 排序字段 ) AS Num FROM 表1 a INNER JOIN 表2 b ON a.关联字段 = b.关联字段 ) tWHERE t.Num BETWEEN 10 AND 20