COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which clause is used to sort the result of SELECT statement?
|
|
SORT BY
|
|
|
ORDER BY
|
|
|
ARRANGE BY
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some databases sort the query results in an ascending order by default.
Detailed explanation-2: -We can sort results in ascending or descending order with an ORDER BY clause in Select statement.
Detailed explanation-3: -Six Operations to Order: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY.
Detailed explanation-4: -Answer: The ORDER BY clause is used to sort the records of a table.
There is 1 question to complete.