title: delete records which are selected from select query on the same table
body: <p>I need to delete few records which I got from a subquery.</p>
  
  <p>Let's say that the <code>EMP</code> table has columns <code>EMPNAME</code>, <code>EMPSALARY</code> and the primary key is a combination of <code>EMPNAME,EMPSALARY</code>.</p>
  
  <pre><code>delete from emp 
  where exists (
          select * 
          from EMP ***** //query which fetch few records from EMP table);
  </code></pre>
  
  <p>The above query is not working.</p>
  
  <p>Thanks for the help.</p>