SQL Database Concepts Interview Question:

Do you know what are various aggregate functions that are available?

Submitted by: Administrator

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.
Submitted by: Administrator