AVG() Aggregate Function in SQL
Table of Content:
The AVG() function returns the average value of a numeric column.
The SUM() function returns the total sum of a numeric column.
Syntax: AVG()
SELECT AVG(column_name) FROM table_name WHERE condition;
We will apply AVG function in this below table:
We will find the AVG employee salary
EmpId |
EmpName |
EmpAddress |
EmpSalary |
EmpDept |
11 |
Rambo |
Kolkata |
30000 |
ADMIN |
21 |
Inza |
Bihar |
31000 |
SALES |
32 |
Samser |
Kolkata |
32000 |
IT |
41 |
Kamran |
Hydrabad |
33000 |
ITIS |
52 |
Azam |
Kolkata |
33000 |
ITIS |
Example: COUNT
Code:
SELECT AVG(EmpSalary) AS AvgSalary FROM EmployeeDetails
You have to remember EmpSalary
is a numeric column
Output:
The above code will produce the following result-
AvgSalary 31800
Code: Required Code to create the table
USE SQLExamples DROP TABLE EmployeeDetails CREATE TABLE EmployeeDetails( EmpId int, EmpName VARCHAR(30), EmpAddress VARCHAR(50), EmpSalary int, EmpDept VARCHAR(10) ) INSERT INTO EmployeeDetails VALUES (11, 'Rambo', 'Kolkata', 30000, 'ADMIN'), (21, 'Inza', 'Bihar', 31000, 'SALES'), (32, 'Samser', 'Kolkata', 32000, 'IT'), (41, 'Kamran', 'Hydrabad', 33000, 'ITIS'), (52, 'Azam', 'Kolkata', 33000, 'ITIS') SELECT * FROM EmployeeDetails