SQL Database Concepts Question:
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.
| 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? |