title: delete mutiple rows with duplicate values
body: <p>i have  an table  like this  with columns  and values now i neeed  to get the  output</p>
  
  <p>like this</p>
  
  <pre><code>ID  DEPID  Address   Name 
  1    1      abc      ram,kumar
  1    1      abc      ram,kumar
  2    2      abc      vinay
  3    2      xyz..    kiran,kumar
  4    6      xyz..    anu
  5    9      xyz..    pavithra
  6    9      xyz..    pavithra,anitha
  6    9      xyz..    pavithra,anitha
  6    9      xyz..    pavithra,anitha
  7    9      xyz..    manu,vachan
  7    9      xyz..    manu,vachan
  7    9      xyz..    manu,vachan
  </code></pre>
  
  <p>now  i need  output like this</p>
  
  <pre><code>ID  DEPID  Address   Name 
  1    1      abc      ram,kumar
  2    2      abc      vinay
  3    2      xyz..    kiran,kumar
  4    6      xyz..    anu
  5    9      xyz..    pavithra
  6    9      xyz..    pavithra,anitha
  7    9      xyz..    manu,vachan
  </code></pre>
  
  <p>pls  help me  how  to get the  Query  for this.</p>