Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Which SQL keyword is used to retrieve a maximum value?

  2. A.

     TOP

    B.

     MOST

    C.

     UPPER

    D.

     MAX

    View Answer

    Workspace

    Answer : Option D

    Explanation :

    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;


Be The First To Comment