title: Count the entire number of rows in an SQL query
body: <p>So I have this query which gives me a list of id's and a count of how many times they are repeating in the particular table.  Though the table is quite large and I am having trouble figuring out how to count the number of rows the query is spitting back.</p>
  
  <p>I tried a self join on the table and and 'IN' clause but couldn't get them to work</p>
  
  <p>Any thoughts?</p>
  
  <pre><code>select id, count(*) as C 
  from tblProduct
  group by id 
  having count(*) &gt; 2
  order by C desc
  </code></pre>