Question 10293 – Engineering-Mathematics
April 18, 2024Question 9823 – Sorting
April 18, 2024Question 13122 – SQL
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”)
Correct Answer: A
Question 135 Explanation:
All condition with empty return true
Also the result of subquery is empty So all id of A will be selected.
3
0
1
4
Subscribe
Login
0 Comments