Find all the tuples having temperature greater than ‘Paris’.
A. SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’
B. SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)
C. SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)
D. SELECT * FROM weather WHERE temperature > ‘Paris’ temperature
Answer:A
Find all the tuples having temperature greater than ‘Paris’.
A. SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’ B. SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’) C. SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’) D. SELECT * FROM weather WHERE temperature > ‘Paris’ temperature
Explanation:Subquery—also referred to as an inner query or inner select—is a SELECT statement embedded within a data manipulation language (DML) statement or nested within another subquery.