Hi Reader's,
  Welcome to FindNerd, today we are going to discuss how to use  Sql Avg () Function in Sql  ?

So, basically this function is used for returning the average of numeric column.If in a table there is null value then this function ignored that value.

Syntax of Sql Avg () function :

select avg (column_name) from table_name where clause;

//Here clause is optional

You can see below example :

Table name : Empl_Info

 Empl_Id         Empl_name          Empl_Age          Empl _Salary
     1                  Deepak                    23                     120000
     2                  Manoj                       24                     250000
     3                  Uday                        20                     420000
     4                  Pradeep                   35                     750000
     5                  Shiva                       26                     820000
     6                  Ravi                         25                     350000

Now we want find the AVG salary of employee list.  

Then we will use below query

select avg (Empl _Salary) from Empl_Info ;

Output will come following:

Average of Empl _Salary is :
    451666.666666667