Which database function is used to calculate values such as COUNT, SUM and AVG?
Options
-
A.
Aggregate functions
-
B.
String functions
-
C.
Date formatting functions
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
A.
Aggregate functions
Detailed Explanation
- Aggregate functions: Perform calculations on a set of rows and return a single result.
- COUNT(): Counts rows or non-NULL values.
- SUM(): Calculates the total of numeric values.
- AVG(): Calculates the average of numeric values.
OOps! You are currently offline.