title: Remove duplicate lines in sql server
body: <p>I have a table with the following example format: </p>
  
  <pre><code>ID Name 
  1  NULL
  1  NULL
  2  HELLO 
  3  NULL
  3  BYE
  </code></pre>
  
  <p>My goal is to remove repeated lines with same IDS, but with restrictions. 
  According to the example,  I need to remove a row with ID-1, and the row with ID-3 and with no value (NULL). </p>
  
  <p>I would stick with the table: </p>
  
  <pre><code>ID Name 
  1  NULL
  2  HELLO 
  3  BYE
  </code></pre>
  
  <p>How can I do this in sql server? thank you</p>