Which SQL keyword is used to retrieve a maximum value?

2024

Which SQL keyword is used to retrieve a maximum value?

  1. A.

    TOP

  2. B.

    MOST

  3. C.

    LEAST

  4. 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;

Explore the full course: Lti Mindtree Preparation