Can you name some aggregate function is SQL Server? | SQL Server interview questions

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.

0 comments:

Post a Comment

Blogger news