SQL query need to get names where count(id) = 2

Question

I have a table programparticipants, I am currently successfully querying the IDs where count(name) > 1. What I need now is to query the names that belong to those IDs where count(name) > 1. Can anyone help me please?

Example, data result currently being returned:

        ID     count(name)
        1      2
        3      4
        4      3

Example, data result needed:

        ID     name
        1      nm1
        1      nm3
        3      nm2
        3      nm3
        3      nm4
        3      nm7
        4      nm5
        4      nm8
        4      nm9

Answer 1

select id, Name 
from programparticipants
where id in ( <your current query selecting only id here> )

Answer 2

You may use this:

SELECT 
   (SELECT name FROM participants WHERE id=p.participantid) AS name
FROM
   programparticipants AS p
WHERE
   .... (the part where you find count(name)>1)

Answer 3

   select count(id), name 
    from  programparticipants 
group by name 
  having count(id) > 1

Answer 4

I think GROUP BY and HAVING are what you want.

Answer 5

Think you'll want to look at group by with having:

select id, name, count(name) from table group by 2,1 having count(name) = 2;

You can substitute = 2 for > 1 depending on whatever you want (title says = 2, question says > 1)

Answer 6

SELECT id, Name
FROM   programparticipants
GROUP BY id, Name
HAVING COUNT(*) > 1