title: Building sql query with count() where count() is > 1
body: <p>If I have a table where there are duplicate IDs, how can I count the number of times the same ID appears in the table and only show records that have a count greater than 1?</p>
  
  <p>I've tried:</p>
  
  <pre><code>SELECT COUNT(ID) AS myCount FROM myTbl
  WHERE myCount &gt; 1 GROUP BY ID
  </code></pre>
  
  <p>But it says <code>myCount</code> is invalid column name. Can someone show me what I'm doing wrong?</p>