Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 26 of 90

Querying Using SQL — Question 4

Back to all questions
4
Question

Question 4

Consider the following query

SELECT * FROM employee ORDER BY salary ............... , name ............... ;

To display the salary from greater to smaller and name in alphabetical order which of the following options should be used ?

  1. Ascending, Descending
  2. Asc, Desc
  3. Desc, Asc
  4. Descending, Ascending
Answer

Desc, Asc
Descending, Ascending

Reason — To display the salary from greater to smaller i.e., in descending order we use DESC or descending keyword and to sort name in alphabetical order i.e., in ascending order we use ASC or ascending keyword.