Which aggregate function returns the highest value from a specified column?

Options

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

Correct Answer (Detailed Explanation is Below)

B. MAX()

Detailed Explanation

  • MAX(): Returns the maximum value from a column or expression.
  • It can be used with numeric, date and comparable text values.
  • Example: SELECT MAX(salary) FROM employees;