title: how to remove duplicate rows from a table in SQL Server
body: <p>I have a table called <code>table1</code> which has duplicate values. It looks like this:</p>
  
  <pre><code>new
  pen
  book
  pen
  like
  book
  book
  pen
  </code></pre>
  
  <p>but I want to remove the duplicated rows from that table and insert them into another table called <code>table2</code>. </p>
  
  <p><code>table2</code> should look like this:</p>
  
  <pre><code>new 
  pen
  book
  like
  </code></pre>
  
  <p>How can I do this in SQL Server?</p>