Multiple choice

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. 4

  2. 3

  3. 0

  4. 1

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

As the result of subquery is an empty table, ‘>ALL’ comparison is true. Therefore, all the three row id’s of A will be selected from table A.