#sql 分页
使用 distinct
SELECT
DISTINCT
a.id,
a.check_no,
a.check_date
a.remark
FROM
A a
INNER JOIN A_detail b ON a.id = b.check_id
WHERE a.is_delete = 0
a.check_no LIKE CONCAT('%', #{checkNo}, '%')
AND b.model_name LIKE CONCAT('%', #{modelName}, '%')