Find all the tuples having a temperature greater than ‘Paris’.

Question

Find all the tuples having a temperature greater than &lsquo;Paris&rsquo;.

Admin · Accepted Answer

SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = &lsquo;Paris&rsquo;

Admin · Answer

SELECT * FROM weather WHERE temperature > &lsquo;Paris&rsquo; temperature

Admin · Answer

SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = &lsquo;Paris&rsquo;)

Admin · Answer

SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = &lsquo;Paris&rsquo;)

Q. Find all the tuples having a temperature greater than ‘Paris’.