Find the temperature in increasing order of all cities, Table Name 'weather'
A. SELECT city FROM weather ORDER BY temperature;
B. SELECT city, temperature FROM weather;
C. SELECT city, temperature FROM weather ORDER BY temperature;
D. SELECT city, temperature FROM weather ORDER BY city;
Answer: Option C
Solution (By Examveda Team)
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.This Question Belongs to SQL >> Sql Miscellaneous
The right answer is option D
Select City, temperature From weather order by city.
1) FROM weather
2) SELECT city, temperature
3) ORDER BY temperature; # sort 0 - 9
1) FROM weather
2) SELECT city, temperature
3) ORDER BY temperature; # sort 0 - 9