adplus-dvertising
frame-decoration

Question

SQL query to find the temperature in increasing order of all cities.

a.

SELECT city FROM weather ORDER BY temperature

b.

SELECT city, temperature FROM weather

c.

SELECT city, temperature FROM weather ORDER BY temperature

d.

SELECT city, temperature FROM weather ORDER BY city

Posted under SQL Server

Answer: (d).SELECT city, temperature FROM weather ORDER BY city

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. SQL query to find the temperature in increasing order of all cities.

Similar Questions

Discover Related MCQs

Q. What is the meaning of LIKE ‘%0%0%’?

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

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.

Q. Find all the tuples having a temperature greater than ‘Paris’.

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

Q. The command to remove rows from a table ‘CUSTOMER’ is __________________

Q. Which is not a type of join in T-SQL?

Q. Which of the following is not a limitation of view?

Q. SQL Server has mainly how many types of views?

Q. Dynamic Management View is a type of ___________

Q. Syntax for creating views is __________

Q. You can delete a view with ___________ command.

Q. What is SCHEMABINDING a VIEW?

Q. Which of the following is not a SQL Server INFORMATION_SCHEMA view?

Q. ___________ is stored only in the Master database.

Q. If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression.

Q. All aggregate functions except __________ ignore null values in their input collection.

Q. A Boolean data type that can take values true, false, and ____________

Q. Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester?

Q. The phrase “greater than at least one” is represented in SQL by ___________