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

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.
Examveda
Question posted by Examveda
Community

Join the Discussion

3 Comments
GOVIND AGRAWAL
GOVIND AGRAWAL 5 years ago
The right answer is option D
Select City, temperature From weather order by city.
Sumeet Gadewar
Sumeet Gadewar 6 years ago
1) FROM weather
2) SELECT city, temperature
3) ORDER BY temperature; # sort 0 - 9
Sumeet Gadewar
Sumeet Gadewar 6 years ago
1) FROM weather
2) SELECT city, temperature
3) ORDER BY temperature; # sort 0 - 9