ExamVeda
Login
Home
This question belongs to SQL Sql Miscellaneous
Sql Miscellaneous
?

Find all the tuples having temperature greater than 'Paris'.

Answer & Solution
Correct Answer: Option A
To find all the tuples (rows) in the "weather" table where the temperature is greater than the temperature in Paris, you should use the SQL query SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris') (Option A). This query correctly uses a subquery to first select the temperature in Paris and then compares it with the temperatures in other cities. If the temperature in a city is greater than that of Paris, the row is included in the result set. This is why Option A is the correct choice.
Examveda
Question posted by Examveda
Community

Join the Discussion

3 Comments
Naveena Jakka
Naveena Jakka 4 years ago
Here the temperature is not mentioned directly but mentioned it's a city so first, we should write a subquery to select the temperature of Paris and then we should compare it to the other cities' temperatures to get the resultant tuples.....Thank you
BIBEK NIROULA
BIBEK NIROULA 4 years ago
detail please
Suraj Shrestha
Suraj Shrestha 8 years ago
how