0 votes
in Oracle by

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;

1 Answer

0 votes
by

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.

Related questions

0 votes
asked Nov 25, 2021 in Oracle by DavidAnderson
0 votes
asked Nov 25, 2021 in Oracle by DavidAnderson
...