Informatics Practices
Select correct SQL query from below 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 ;
SQL Queries
3 Likes
Answer
SELECT city, temperature FROM weather ORDER BY city ;
Reason — The query SELECT city, temperature FROM weather ORDER BY city ; selects the city and temperature columns from the weather table and sorts the result set by the city column in ascending order.
Answered By
2 Likes
Related Questions
To create summary results, …………… clause is used.
- SORT BY
- SUMMARY BY
- GROUP BY
- ORDER BY
Consider the following query
SELECT * FROM employee ORDER BY salary ..............., name ...............;To display the salary from greater to smaller and name in alphabetical order which of the following options should be used ?
- Ascending, Descending
- Asc, Desc
- Desc, Asc
- Descending, Ascending
Which SQL function is used to count the number of rows in a SQL query ?
- COUNT()
- NUMBER()
- SUM()
- COUNT(*)
Which SQL statement do we use to find out the total number of records present in the table ORDERS ?
- SELECT * FROM ORDERS;
- SELECT COUNT(*) FROM ORDERS ;
- SELECT FIND (*) FROM ORDERS ;
- SELECT SUM() FROM ORDERS ;