Home Modern Forums ORACLE 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
Reply 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;

I had been asked this question during a job interview.

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

Up
0
Down
::

nan