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

Last updated at April 16, 2024 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

 

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:

Ask a doubt
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.