Multiple choice technology mainframe

Which funtion is used to return the total of a numeric field?

  1. COUNT()

  2. GROUP BY()

  3. SUM()

  4. MAX()
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SUM() is the aggregate function that returns the total (sum) of values in a numeric column. COUNT() returns the number of rows, not a sum. GROUP BY is used for grouping rows, not aggregation. MAX() returns only the maximum value, not the total.

Keep practicing — related questions