Question
a.
SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
b.
SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)
c.
SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)
d.
SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);
Posted under SQL Server
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.
Similar Questions
Discover Related MCQs
Q. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.
View solution
Q. Find all the tuples having a temperature greater than ‘Paris’.
View solution
Q. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.
View solution
Q. The command to remove rows from a table ‘CUSTOMER’ is __________________
View solution
Q. Which is not a type of join in T-SQL?
View solution
Q. Which of the following is not a limitation of view?
View solution
Q. SQL Server has mainly how many types of views?
View solution
Q. Dynamic Management View is a type of ___________
View solution
Q. Syntax for creating views is __________
View solution
Q. You can delete a view with ___________ command.
View solution
Q. What is SCHEMABINDING a VIEW?
View solution
Q. Which of the following is not a SQL Server INFORMATION_SCHEMA view?
View solution
Q. ___________ is stored only in the Master database.
View solution
Q. If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression.
View solution
Q. All aggregate functions except __________ ignore null values in their input collection.
View solution
Q. A Boolean data type that can take values true, false, and ____________
View solution
Q. Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester?
View solution
Q. The phrase “greater than at least one” is represented in SQL by ___________
View solution
Q. We can test for the nonexistence of tuples in a subquery by using the __________ construct.
View solution
Q. Which of the following command is used to get child items in powershell?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
