sql 查询重复的数据

select * from yryz_role_partner where user_id in (select user_id from yryz_role_partner group by user_id having count(1) >= 2)