title: sql select records having count > 1 where at lease one record has value
body: <p>I'm trying to get all participants that have more than 1 record in the table where at lease one of those records has IsCurrent = 0 and IsActive = 1</p>
  
  <p>This is what I have so far, but it's not working:</p>
  
  <pre><code>    SELECT  ParticipantId 
      FROM Contact
      WHERE (IsCurrent = 0 AND IsActive = 1 AND ContactTypeId = 1)
      Group by ParticipantId
      Having COUNT(ParticipantId) &gt; 1
  </code></pre>
  
  <p>This query brings back a record that matches that description, but I need all of the records that match that description, there are more.</p>