Examveda
Examveda

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;

Answer: Option C

Join The Discussion

Comments ( 2 )

  1. Sumeet Gadewar
    Sumeet Gadewar :
    4 months ago

    1) FROM weather
    2) SELECT city, temperature
    3) ORDER BY temperature; # sort 0 - 9

  2. Sumeet Gadewar
    Sumeet Gadewar :
    4 months ago

    1) FROM weather
    2) SELECT city, temperature
    3) ORDER BY temperature; # sort 0 - 9

Related Questions on Sql Miscellaneous