devxlogo

October 5, 2017

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