Is there a simple way to get the row count of the results of an aggregate query. e.g. @@rowcount. I have a complex query and don't really care about the actual results. Expecting 40m+ matches.

count(*)

I cannot nest select count(*) from (select key, max(val) from ... group by key ... )

Do you mean group count? That’s the same as count distinct on group by column