?
Find the temperature in increasing order of all cities, Table Name 'weather'
Answer & Solution
Correct Answer:
Option
C
To retrieve the temperature of all cities in increasing order, you should use the SQL query SELECT city, temperature FROM weather ORDER BY temperature; (Option C). This query selects both the "city" and "temperature" columns from the "weather" table and arranges the result set in ascending order based on the "temperature" column. As a result, you'll get the temperature values for all cities listed from the lowest to the highest temperature.
Join the Discussion
Login to post a comment or share your explanation.
LoginSelect City, temperature From weather order by city.
2) SELECT city, temperature
3) ORDER BY temperature; # sort 0 - 9
2) SELECT city, temperature
3) ORDER BY temperature; # sort 0 - 9