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;
OOps! You are currently offline.