R

Ram Sharma • 193.86K Points
Coach 

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.

  • (A) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70
  • (B) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
  • (C) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70
  • (D) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70
  • Correct Answer - Option(B)
  • Views: 118
  • Filed under category SQL Server

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. Which of these commands is used if we want in a PowerShell to get child items?

Q. You want to track date and time of the last write access per row. Select the suitable option among the below.

Q. Which of the following is a database object?

Q. ______________ is schematic drawing used for representing relationships in database.

Q. SQL server 2005 supports fields line

Q. In SQL, Which Command(s) Is(are) Used To Change A Table's Storage Characteristics?

Q. SQL query to find all the cities whose humidity is 95.

Q. Which of these statements can we check for Errors?

Q. Which of the following operating system is Supported by IA-64 Edition?

Q. What is the full form of SQL.

Learn All SQL Server MCQs

Question analytics