Interview Questions And Answers Forum

hasnain

Administrator

From: Chichawatni

Registered: 2014-10-13

Posts: 8,355

Website

SQL Temperature:

http://interviewquestionsanswers.org/quiz/Database http://interviewquestionsanswers.org/qu … L-Database

Question:
Find the temperature in increasing order of all cities:

Option A):
SELECT city FROM weather ORDER BY temperature;
Option B):
SELECT city, temperature FROM weather ORDER BY temperature;
Option C):
SELECT city, temperature FROM weather;

Correct Answer is Option B):
SELECT city, temperature FROM weather ORDER BY temperature;

---

Failure is the first step towards seccess.