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

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

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.

Syntax:
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