Global Web Forum

husnain

Administrator

From: Chichawatni,Pakistan

Registered: 2014-10-03

Posts: 8,129

Website

SQL Quiz Question.

Database Quizzes SQL

Question:
Find the name of all cities with their temperature, humidity and countries.

Option A):
SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
Option B):
SELECT weather.city, temperature, humidity, country FROM weather, location;
Option C):
SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

Correct Answer is Option A):
SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

---

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