Question

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

The question was asked at a job interview.

Query is from Basic SQL topic in chapter Laying the Foundation of SQL Server

Answer 1

Right option is (d) SELECT city, temperature FROM weather ORDER BY city

Explanation: The ORDER BY keyword sorts the records in ascending order by default.