Interview Questions And Answers Forum

hasnain

Administrator

From: Chichawatni

Registered: 2014-10-13

Posts: 8,355

Website

SQL Quiz:

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

Question:
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy:

Option A):
SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');
Option B):
SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');
Option C):
SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

Correct Answer is Option B):
SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

---

Failure is the first step towards seccess.