What is the use of Avg function in Sql-Server?

 Posted by Rajesh_Kumar on 1/22/2014 | Category: Sql Server Interview questions | Views: 2389 | Points: 40

AVG() function is an in-built Sql-Server function which is used to calculate the average of a column values.
Note:Column must be of Integer type.

Select Avg(column_name) From table_name;

For Example:
Select Avg(Budget) from Project_Master;

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response