COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
SQL query to find all the cities whose humidity is 95.
|
SELECT city WHERE humidity = 95
|
|
SELECT city FROM weather WHERE humidity = 95
|
|
SELECT humidity = 89 FROM weather
|
|
SELECT city FROM weather
|
Explanation:
Detailed explanation-1: -It can be used with the SELECT, INSERT, UPDATE and DELETE statement. The IN is a conditional operator used to reduce the use of multiple OR conditions in the SELECT, INSERT, UPDATE and DELETE statement. Hence the option B is the correct choice.
Detailed explanation-2: -The correct answer to the question “Which of the SQL statements is correct” is option (b). SELECT Username, Password FROM Users. And all the other options are incorrect.
Detailed explanation-3: -In a SQL statement, the WHERE clause specifies criteria that field values must meet for the records that contain the values to be included in the query results.
There is 1 question to complete.