CodesJava

Easy learning with example program codes

AVG function in MySQL

MySQL AVG
In MySQL, the AVG function is used to get the average value of an expression.
Syntax:

SELECT AVG (aggregate_expression)  
FROM table_name  
WHERE conditions;

Parameters:
Aggregate_expression: It is used to specify the column or expression to be utilised by the AVG function.

Example:
Items table:

ID	NAME	        QUANTITY
1	Electronics	30
2	Sports	        45
3	Fashion	        100
4	Electronics	90
5	Sports	        50

Query:

SELECT AVG(quantity) AS “Average Quantity”
FROM items;

Output:

AVERAGE QUANTITY
63
1 row in set <0.00 sec>

Explanation:
The ‘items’ is an already existing table from which we are calculating the average value of ‘quantity’.

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status