Javatpoint Logo
Javatpoint Logo

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:

MariaDB Avg function 1

Let's retrieve the average salary of the employees from the table.


MariaDB Avg function 2

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:


MariaDB Avg function 3

It will increase the salary by 50%.

AVG() Salary with ORDER BY Clause


MariaDB Avg function 4
Next TopicMariaDB Inner Join

Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA