You are not logged in.

#1 2015-09-18 06:15:16

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.

2015-09-18 06:15:16

Advertisement
Ads By Google

Re: SQL Quiz:



Board footer