title: MySQL: how to get records with count > 1?
body: <p>I have a sql like this:</p>
  
  <pre><code>SELECT *, count(*) as cc 
  FROM manytomany 
  GROUP BY aid, bid
  ORDER BY cc DESC
  </code></pre>
  
  <p>which return all records with the count #.</p>
  
  <p>however, what can I do if I only want to get the ones with count > 1?</p>