title: sql : how to find duplicates rows?
body: <p>i got a table users (id,first_name,last_name,...)
  i want to find duplicate users in that table (users which has the same first_name AND the same last_name).</p>
  
  <p>let's say my data is :</p>
  
  <pre><code> 1;bill;campton
   2;sarah;connor
   3;bill;campton
  </code></pre>
  
  <p>i need to get</p>
  
  <pre><code>  1;bill;campton;3;bill;campton
  </code></pre>
  
  <p>i dont want to get</p>
  
  <pre><code>  1;bill;campton;3;bill;campton
    3;bill;campton;1;bill;campton
  </code></pre>
  
  <p>How could i do that?
  I use SQL Server 2005</p>
  
  <p>thank you</p>