Can you name some aggregate function is SQL Server?

 Posted by ArticlesMaint on 10/3/2009 | Category: Sql Server Interview questions | Views: 7475


Some of them which every interviewer will expect: -


• AVG: - Computes the average of a specific set of values, which can be an expression list or a set of data records in a table.


• SUM: - Returns the sum of a specific set of values, which can be an expression list or a set of data records in a table.


• COUNT: - Computes the number of data records in a table.


• MAX: - Returns the maximum value from a specific set of values, which can be an expression list or a set of data records in a table.


• MIN: - Returns the minimum value from a specific set of values, which can be an expression list or a set of data records in a table.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response