I have a table in which I need to select only the participants who have multiple rows. I tried the group by and having count(*) > 1 but I need to display each time they are in the table but only if they are in more than one. Thanks.