查询多条件相同的重复数据

查询多条件相同的重复数据 mysql 语句

SELECT
tbl.user_id,
tbl.lesson_id,
tbl.evaluation_id,
count( 0 ) count
FROM
(
SELECT
*
FROM
tbl_evaluation_record a
WHERE
( a.user_id, a.lesson_id, a.evaluation_id ) IN ( SELECT user_id, lesson_id, evaluation_id FROM tbl_evaluation_record GROUP BY user_id, lesson_id, evaluation_id HAVING count( * ) > 1 )
AND STATUS = 1
) tbl
GROUP BY
tbl.user_id,
tbl.lesson_id,
tbl.evaluation_id
HAVING
count > 1;/