Informatics Practices
Which one of the following would arrange the rows in ascending order in SQL ?
- SORT BY
- ALIGN BY
- GROUP BY
- ORDER BY
SQL Queries
1 Like
Answer
ORDER BY
Reason — The ORDER BY clause in SQL is used to sort the result set in either ascending or descending order.
Answered By
1 Like
Related Questions
Which function can you use with ORDER BY clause to specify custom sort order ?
(a) SORT()
(b) CUSTOM()
(c) FIELD()
(d) All of these
By default, ORDER BY clause lists the results in …………… order.
- Descending
- Any
- Same
- Ascending
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