MySQL Average Command


 

MySQL Average Command

This example illustrates how to execute the Average command in MySQL.

This example illustrates how to execute the Average command in MySQL.

MySQL Average Command

This example illustrates how to execute the Average command in MySQL.

In this example we create a select query to find the average of 'lastAccess' field.

 

Query

 

Output

 

select AVG(lastAccess) from emp;

 

+---------------------------+
| AVG(lastAccess)           |
+---------------------------+
| 16734273156259.9450000000 |
+---------------------------+

 

Ads