Global Web Forum

husnain

Administrator

From: Chichawatni,Pakistan

Registered: 2014-10-03

Posts: 8,129

Website

SQL Quiz:

Database Quizzes SQL

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');

---

You cannot discover the new oceans unless you have the courage to lose the sight of the shore.