COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
ASC
|
|
DESC
|
|
There is no default value
|
|
None of the mentioned
|
Detailed explanation-1: -The ASC keyword helps us sort in ascending order while the DESC sorts in descending order. If no keyword is specified in which we have to sort the records in the column, it will take its default value. ‘It sorts the records in ascending order by default.
Detailed explanation-2: -The ASC keyword is used to sort the query result set in an ascending order. The default for ORDER BY when nothing has been explicitly specified is ASC.
Detailed explanation-3: -If you don’t specify ASC or DESC, PostgreSQL will assume you want to see results: in ascending order.
Detailed explanation-4: -By default, SQL Server sorts out results using ORDER BY clause in ascending order.
Detailed explanation-5: -By default ORDER BY sorts the data in ascending order. We can use the keyword DESC to sort the data in descending order and the keyword ASC to sort in ascending order.