SQL AVG() Function


The SQL AVG() is a function, and return average value of a table column from query result.

The SQL AVG() function is supports only numeric column.

It can be used in SQL SELECT statement as well in SQL WHERE clause.

You can also search these topics using sql average function, sql average of sum, sql server average, sql average count, sql server average function, sql server average count.

SQL AVG() Syntax

The below syntax is used to select specific column from the specific table.


SELECT AVG(column_name1) FROM table_name;


Sample Database Table - Employee

ID EmpName Designation Dept JoinYear Salary
1 Chandra Data Mining ASP.Net 2013 15440
2 Padmavathi Database Security C#.Net 2012 17540
3 Dharan Manager Java 2014 20480
4 Rishi Keshan Mobile Database MS Access 2015 3470.7
5 Vinoth Kumar Data Mining Java 2012 5780
6 Sakunthala Information Tech C#.Net 2012 9560

SQL AVG() Example

The following SQL SELECT statement find the average salary of all employees from the "Employee" table:


SELECT 
AVG(Salary) As 'Average Salary' 
FROM Employee;

The result of above query is:

Average Salary
12045.116

SQL AVG() Example - Using SQL WHERE Clause

The following SQL SELECT statement find the average salary of all employees, which has salary less than 10000 from the "Employee" table:


SELECT 
AVG(Salary) As 'Average Salary' 
FROM Employee 
WHERE Salary < 10000;

The result of above query is:

Average Salary
6270.233

SQL AVG() Example - Using Group By Clause

The following SQL SELECT statement find the average salary by grouping "Dept" column of all employees from the "Employee" table:


SELECT 
Dept, AVG(Salary) As 'Average Salary' 
FROM Employee 
GROUP BY Dept;

The result of above query is:

Dept Average Salary
ASP.Net 15440
C#.Net 13550
Java 13130
MS Access 3470.7
You can also search these topics using sql query for average, sql query average, select average sql, aggregate functions in sql, sql aggregate functions, sql aggregate functions examples, aggregate sql functions, sql aggregate functions with examples.