title: Delete based on a group in SQL Server
body: <p>I want to delete records with the same combination of records from a table using this query. The syntax works in PostgreSQL but not in SQL Server. What could be the reason?</p>
  
  <pre><code>    DELETE FROM  Table_stg
           WHERE (cid , t_date , i_location , item ) in
               (SELECT b.cid , b.t_date, b.i_location, b.itemFROM  Table_vw b)
  </code></pre>