SQL Server Transact Basic to Expert - Using Average function

Karthikeyan Anbarasan
13y
3.1k
0
0

Blog

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.

SQL Server Transact Basic to Expert - Using Average function

Up Next

SQL Server Transact Basic to Expert - Using Count Aggregate function

Ebook Download

View all

Functions in SQL Server: Practical Guide

Read by 9k people

Download Now!

Learn

View all