1.

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» 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.


Discussion

No Comment Found

Related InterviewSolutions