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

M

Mr. Dubey

🎓 Coach ⭐ 103.80K Points

📊 Database Management System (DBMS)

Q. Find all the tuples having a 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

💬 Discuss

✅ Correct Answer: (A) SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’

You must be Logged in to update hint/solution

💬 Discussion

📊 Question Analytics

👁️

482

Total Visits

📽️

3 y ago

Published

🎖️

Mr. Dubey

Publisher

📈

91%

Success Rate