Consider the following relation schema R along with the tuples. Employee(name,…

PYQ Coal India Management Trainee CBT 2017Modified — slightly modified from the official paper; see the solution

Consider the following relation schema R along with the tuples.

Employee(name, salary) = {<e1, 10000>, <e2, 5000>, <e3, 2500>, <e4, 7500>, <e5, 8900>, <e6, 9800>}

What is the output of following SQL query?

SELECT name, MAX(salary) FROM Employee WHERE salary < (SELECT MAX(salary) FROM Employee);

  1. A.

    <e3, 2500>

  2. B.

    <e5, 8900>

  3. C.

    <e6, 9800>

  4. D.

    <e1, 10000>

Attempted by 743 students.

Sign up free to check your answer

Sign up free

Explore the full course: Coal India Management Trainee

Loading lesson…