Javatpoint Logo
Javatpoint Logo

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




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA