title: SQL query need to get names where count(id) = 2
body: <p>I have a table <code>programparticipants</code>. I am currently successfully querying the IDs where <code>count(name) &gt; 1</code>. What I need now is to query the names that belong to those IDs where <code>count(name) &gt; 1</code>.</p>
  
  <p>Example, data result currently being returned:</p>
  
  <pre><code>ID     count(name)
  1      2
  3      4
  4      3
  </code></pre>
  
  <p>Example, data result needed:</p>
  
  <pre><code>ID     name
  1      nm1
  1      nm3
  3      nm2
  3      nm3
  3      nm4
  3      nm7
  4      nm5
  4      nm8
  4      nm9
  </code></pre>