Thursday, August 16, 2012

Can you name some aggregate function is SQL Server?

Answer:
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.

No comments:

Post a Comment