Consider the following relations A, B and C: How many tuples does the result…

PYQ GATE 2012

Consider the following relations A, B and C:

How many tuples does the result of the following SQL query contain?

SELECT A.Id
FROM A
WHERE A.Age > ALL (SELECT B.Age
                   FROM B
                   WHERE B.Name = ‘Arun’)
  1. A.

    4

  2. B.

    3

  3. C.

    0

  4. D.

    1

Attempted by 524 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…