R

Ram Sharma • 193.86K Points
Coach 

Q. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

  • (A) SELECT * FROM weather WHERE humidity IN (63 to 79)
  • (B) SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
  • (C) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
  • (D) SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

Correct answer: Option(C)

SQL Server Share

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on SQL Server

Q. ________ is tool in SSMS used to manage multiple servers.

Q. Business intelligence (BI) is a broad category of application programs which includes _____________

Q. With SQL, how can you return the number of not null records in the “Persons” table?

Q. Which of the following is a feature of SQL Server 2008 R2 Datacenter?

Q. Which of the following joins are SQL server default?

Q. Which of the following is a large object data type?

Q. What is the purpose of the SQL AS clause?

Q. Which of the following language is used for procedural flow in SQL Server?

Q. Which of the data type has a storage size of 8 bytes?

Q. Syntax for viewing the methods and properties we can pipe our output to Get-Member by ______________

Learn All SQL Server MCQs