Check sibling questions

This question asked in CBSE SQP-2020

Which keyword is used to sort the records of a table in descending order?

 

Answer:

The keyword DESC is used to sort the records of a table in descending order.

Syntax: SELECT column1 , column2, …   

              FROM table_name  

              ORDER BY column1, column2, ... DESC ;

 

Syntax: SELECT column1 , column2, …   

              FROM table_name  

              ORDER BY column1, column2, ... DESC ;

 

Example:

Question 1 Very short- image 1.jpg

Question 1 Very short- image 2.jpg

 


Transcript

This question asked in CBSE SQP-2020 Which keyword is used to sort the records of a table in descending order? Answer: The keyword DESC is used to sort the records of a table in descending order. Syntax: SELECT column1, column2, … FROM table_name ORDER BY column1, column2, ... DESC; Syntax: SELECT column1, column2, … FROM table_name ORDER BY column1, column2, ... DESC; Example:

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.