SQL Server Transact Basic to Expert - Using Count Aggregate function

This blog shows how to use the Count funtion to get the count of the desired columns.

Example:

SELECT  ProductNames, COUNT(ProductID) ProductCount
FROM  DBO.Products
GROUP BY ProductNames
ORDER BY ProductNames

COUNT() - this is the function used to get the count.