如何实现多表关联的查询和分页,最好给个

2025-03-23 16:50:17
推荐回答(1个)
回答1:

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