UTpaper

Free mock tests & test series

Question 160Asked in CIL MT Systems, 26 Mar 2017 (12:30 PM)

Consider the following relation schema R along with the tuples.

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>
Show answerHide answer

Correct answer: (C) <e6, 9800>

From CIL MT Systems PYQ, 26 Mar 2017 (12:30 PM)

This is question 160 of CIL MT Systems PYQ, 26 Mar 2017 (12:30 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.