Which aggregate function calculates the sum of values in a numeric column?

Options

  • A. COUNT()
  • B. AVG()
  • C. SUM()
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. SUM()

Detailed Explanation

  • SUM(): Calculates the total of numeric values in a column or expression.
  • NULL values are ignored.
  • Example: SELECT SUM(salary) FROM employees;