title: retrieving duplicates in table and displaying them
body: <p>I have got the following table where if more than 1 row contain the same  'user_badge_name' and the 'user_email', the are considered duplicates.</p>
  
  <pre><code>user_id | user_name | user_badge_name | user_email
  --------------------------------------------------
  234     | Kylie     | ky001           | kylie@test.com
  235     | Francois  | FR007           | france@test.com 
  236     | Maria     | MA300           | Marie@test.com
  237     | Francine  | FR007           | france@test.com 
  </code></pre>
  
  <p>I need to display the user_ids and username of those rows where 'user_badge_name' and 'user_email' are replicated.</p>
  
  <p>I tried the following sql but it is not returning all user_ids, only the first id</p>
  
  <pre><code>SELECT user_id, username , COUNT(user_badge_name) AS user_badge_name_Count FROM user GROUP BY user_badge_name HAVING user_badge_name_Count &gt; 1
  </code></pre>
  
  <p>Any suggestion is most appreciated</p>