COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
SQL query to find the temperature in increasing order of all cities.
|
|
SELECT city FROM weather ORDER BY temperature
|
|
|
SELECT city, temperature FROM weather
|
|
|
SELECT city, temperature FROM weather ORDER BY temperature
|
|
|
SELECT city, temperature FROM weather ORDER BY city
|
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.
There is 1 question to complete.