Loading

SQL Server Transact Basic to Expert - Using Average function

Karthikeyan Anbarasan

Comments

Join the conversation! Your thoughts help the community grow.

This blog shows how to do an average of group of values using the Average function in SQL Server

Example:

SELECT ProductID, AVG(Rating) AverageRating
FROM DBO.ProductReview
GROUP BY ProductID

AVG() - this is the function used to do the average.