SQL AVG
The SQL AVG aggregate function selects the average value for certain table column.
Have a look at the SQL AVG syntax:
SELECT AVG(Column1)
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:
|
