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 |
+---------------------------+

Related Tags for MySQL Average Command: