R

Ram Sharma • 193.86K Points
Coach 

Q. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

  • (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’);
  • Correct Answer - Option(A)
  • Views: 127
  • 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. Embedded SQL is which of the following?

Q. __________ convert object properties into CSV objects.

Q. Which of the following is a feature of SQL Server 2014?

Q. SQL server 2005 introduces notification support for

Q. Point out the correct statement.

Q. Which of the following is a feature of SQL Server 2012 R2 Enterprise?

Q. Which of these backups are taken in full recovery models only or in bulk?

Q. Ctrl+K+K shortcut refers to ___________

Q. Syntax for creating views is __________

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.

Learn All SQL Server MCQs

Question analytics