How do you count the rows in a SQL query which alredy used count, group by, and having before?

Question

For example, using the answer for this question:

http://stackoverflow.com/questions/152024/how-to-select-all-users-who-made-more-than-10-submissions "How to select all users who made more than 10 submissions."

select userId
from submission   
group by userId
having count(submissionGuid) > 10

Let's say now I want to know many rows this sql statement outputted. How scalable is the solution for counting the rows of counting the rows?

Answer 1

In SQL Server you could do

select @@ROWCOUNT

immediately following the query you posted.

Answer 2

Nested queries:

select count(*) from
  (select userId
   from submission   
   group by userId
   having count(submissionGuid) > 10) n

Edited to incorporate mbrierst's comment about needing an alias (the "n" at the end) for the nested subquery. Oracle does not require this, but SQL Server does. Feel free to add a comment regarding usage on other database platforms.