Discussion :: SQL Server MCQs
- 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
|
Answer : Option D
Explanation :
The ORDER BY keyword sorts the records in ascending order by default.
Be The First To Comment