SQL Tutorial - Learn SQL

SQL AVG - SQL Tutorial

The SQL AVG aggregate function selects the average value for certain table column.

Have a look at the SQL AVG syntax:

FROM Table1

If we want to find out what is the average SaleAmount in the Sales table, we will use the following SQL AVG statement:

SELECT AVG(SaleAmount) AS AvgSaleAmount
FROM Sales

which will result in the following dataset: