SQL Database Concepts Question:
Download Job Interview Questions and Answers PDF
Do you know what are various aggregate functions that are available?
Answer:
The following are various aggregate functions available:-
1. SUM
2. AVG
3. COUNT
4. COUNTDISTINCT
5. MAX
6. MIN
7. STDEV
8. STDEVP
9. VAR
10. VARP
By default, SUM is the aggregate function used for numeric data type.
1. SUM
2. AVG
3. COUNT
4. COUNTDISTINCT
5. MAX
6. MIN
7. STDEV
8. STDEVP
9. VAR
10. VARP
By default, SUM is the aggregate function used for numeric data type.
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can you explain what are various ways to enhance the SSRS report? | Explain how to integrate the SSRS reports in application? |