Global Web Forum

husnain

Administrator

From: Chichawatni,Pakistan

Registered: 2014-10-03

Posts: 8,129

Website

SQL Entries:

Database Quizzes SQL

Question:
Find the name of cities with all entries whose temperature is in the range of 71 and 89:

Option A):
SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
Option B):
SELECT * FROM weather WHERE temperature NOT IN (71 and 89);
Option C):
SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;

Correct Answer is Option A):
SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;

---

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