You are not logged in.

#1 2015-09-18 06:19:42

hasnain
Administrator
From: Chichawatni
Registered: 2014-10-13
Posts: 8,355
Website

SQL Quiz Question.

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

Question:
Find the names of the countries whose condition is sunny.

Option A):
SELECT country FROM location WHERE condition = 'sunny';
Option B):
SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');
Option C):
SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');

Correct Answer is Option C):
SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');


Failure is the first step towards seccess.

2015-09-18 06:19:42

Advertisement
Ads By Google

Re: SQL Quiz Question.



Board footer