devxlogo

Summing a COUNT Aggregate SQL Function

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 TotalCountfrom(    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

devx-admin

Share the Post: