title: SQL - How do I add a count to my table which has been a result from a query
body: <p>I've retrieved a count of the duplicates and their occurrences using the below code</p>
  
  <pre><code>select empID, count(empID) AS DUPLICATEempID
  from employees
  group by empID
  having count (empID) &gt; 1
  </code></pre>
  
  <p>I now want the table to include the number of rows returned (i.e. insert the number on the table returned)</p>
  
  <p>thanks in advance. </p>