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:
|
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:
| AvgSaleAmount |
| $195.73 |