The 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 AVG statement:
|
SELECT AVG(SaleAmount) AS AvgSaleAmount
FROM Sales |
which will result in the following dataset:
|
AvgSaleAmount
|
|
$195.73
|
No comments:
Post a Comment