SQL query to find the temperature in increasing order of all cities.
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:A
SQL query to find the temperature in increasing order of all cities.
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
Explanation:The ORDER BY keyword sorts the records in ascending order by default.