Which SQL keyword is used to retrieve a maximum value?
2024
Which SQL keyword is used to retrieve a maximum value?
- A.
TOP
- B.
MOST
- C.
LEAST
- D.
MAX
Attempted by 1795 students.
Show answer & explanation
Correct answer: D
Answer: Option D
Solution:
MAX function is used to get the maximum value from a column. To get the maximum salary drawn by an employee, the query would be:
SELECT MAX (salary) FROM employee;