Question 1 - Past Year - 1 Mark Questions - Chapter 9 - Structured Query Language

Last updated at August 2, 2026 by

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

 

Remove Ads

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 - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh is an IIT Kanpur graduate and has been teaching for 16+ years. At Teachoo, he breaks down Maths, Science and Computer Science into simple steps so students understand concepts deeply and score with confidence.

Many students prefer Teachoo Black for a smooth, ad-free learning experience.