title: Deleting Records in SQL using a DELETE query
body: <p>Below is the query I have which returns results that I want to delete from a table.</p>
  <pre><code>SELECT * 
  FROM tableA
  GROUP BY id
  HAVING COUNT(*) &gt; 5 
  </code></pre>
  <p>How do I go about deleting the records that show up from this query? I was thinking of using this <code>DELETE</code> query.</p>
  <pre><code>DELETE FROM tableA
  WHERE 
       (SELECT * 
        FROM tableA
        GROUP BY id
        HAVING COUNT(*) &gt; 5)
  </code></pre>
  <p>But this does not seem to be working.</p>