MariaDB AVG() Function
MariaDB AVG() function is used to retrieve the average value of an expression.
AVG() Function with single expression
We have a table "Employee2", having the following data:
Let's retrieve the average salary of the employees from the table.
Use AVG() Function with Formula
You can use AVG() function also with mathematical formula. For example, if you want to increase the average salary of your employees by 50%, you can use the following formula to estimate the cost:
It will increase the salary by 50%.
AVG() Salary with ORDER BY Clause