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')

Question

Consider the following relations A, Band C:

A

Id	Name	Age
12	Arun	60
15	Shreya	24
99	Rohit	11

 

B

Id	Name	Age
15	Shreya	24
25	Hari	40
98	Rohit	20
99	Rohit	11

C

Id	Phone	Area
10	220	02
99	2100	01

 

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')

(A) 4 

(B)3 

(C)O 

(D) 1

Answer 1

Correct option is  (B) 3

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