Q. Find all the tuples having a temperature greater than ‘Paris’.
-
(A)
SELECT * FROM weather WHERE temperature > ‘Paris’ temperature
-
(B)
SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)
-
(C)
SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)
-
(D)
SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’
โ
Correct Answer: (D)
SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’