MCQ IN COMPUTER SCIENCE & ENGINEERING

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 ____
A
Ascending, descending
B
Asc, Desc
C
Desc, Asc
D
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.