Discussion Forum

Que. Table A
Id Name Age
----------------
12 Arun 60
15 Shreya 24
99 Rohit 11

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

Table C
Id Phone Area
-----------------
10 2200 02
99 2100 01
Consider the above tables A, B and C. How many tuples does the result of the following SQL query contains?
SELECT A.id
FROM A
WHERE A.age > ALL (SELECT B.age FROM B
WHERE B. name = "arun")
a. 4
b. 3
c. 0
d. 1
Answer:3
Swati :(September 23, 2020) But relation B does not contains name = Arun..
But B realation does not contain name varun
i think answer is incorrect because there is no tuple in table b name ARUN
id also not contain 3
Click to Add Comment

Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: