Question

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;

I had been asked this question during a job interview.

Enquiry is from Structured Query Language topic in portion SQL Basics of Oracle

Answer 1

Correct answer is (c) SELECT city, temperature FROM weather ORDER BY temperature;

To explain I would say: SELECT column_name, aggregate_function(column_name)

 FROM table_name

 WHERE column_name operator value

 GROUP BY column_name

 HAVING aggregate_function(column_name) operator value

 ORDER BY ;

So base on [SELECT city, temperature FROM weather ORDER BY temperature;] this will be the correct answer.