Home » MariaDB Avg Function

MariaDB Avg Function

by Online Tutorials Library

MariaDB AVG() Function

MariaDB AVG() function is used to retrieve the average value of an expression.

Syntax:

Or

Example:


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.

Output:

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:

Output:

MariaDB Avg function 3

It will increase the salary by 50%.


AVG() Salary with ORDER BY Clause

Output:

MariaDB Avg function 4

Next TopicMariaDB Inner Join

You may also like