COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In the following Query, which of the following can be placed in the Query’s blank portion to display the salary from highest to lowest amount, and sorting the employs name alphabetically?SELECT * FROM instructor ORDER BY salary ____, name ____
|
Ascending, descending
|
|
Asc, Desc
|
|
Desc, Asc
|
|
All of the above
|
Explanation:
Detailed explanation-1: -Expl:-To sort the salary from highest to lowest amount and display theemployee’s name alphabetically, one can use the “Desc and Asc” in the above-given Query.
There is 1 question to complete.