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.
SQL Server Transact Basic to Expert - Using Count Aggregate function
SQL Server Transact Basic to Expert - Using Count Aggregate function
Join the conversation! Your thoughts help the community grow.