数据库操作遇到的问题

1.查找id重复的数据

select * from bas_workshop where workshop_id in (select workshop_id from bas_workshop group by workshop_id having count(*) > 1)