SQLTeam.com | Weblogs | Forums

Gathering distinct department names and counting each


#1

Closed as the solution was found


#2

select department_name, count(*) as number_of_modules
from module
group by department_name


#3

Thank you, this did pretty much exactly what I was looking for