COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
ASC
|
|
|
DESC
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default.
Detailed explanation-2: -Specifies that the values in the specified column should be sorted in ascending or descending order. ASC sorts from the lowest value to highest value. DESC sorts from highest value to lowest value. ASC is the default sort order.
Detailed explanation-3: -The ASC keyword specifies that you want the data to appear in ascending order; this is the default if no sequence is specified. The DESC keyword specifies that you want the data to appear in descending order.
Detailed explanation-4: -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.
Detailed explanation-5: -By default, SQL Server sorts out results using ORDER BY clause in ascending order.