This example illustrates how to execute the Average command in MySQL.
This example illustrates how to execute the Average command in MySQL.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 | +---------------------------+
|