Tip: Summing a COUNT Aggregate SQL Function

The following code snippet shows a small example of how you can sum the result of a count aggregate function.

select sum(studentcount) as TotalCount
from
(
    SELECT  
        count(s.studentname) as studentcount,
        s.studentname as studentname
    FROM [students] as s  
    group by s.studentname 
    order by count(s.studentname) desc 
)a

Visit the DevX Tip Bank