Q12
Which SQL keyword is used to retrieve a maximum value?
A.
TOP
B.
MOST
C.
UPPER
D.
MAX
AnswerAnswer: Option D
Solution
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;