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

GATE · 2012 · CS · Computer Science & IT

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 375 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…