This question asked in CBSE SQP-2020

Which clause is used to sort the records of a table?

 

Answer:

The ORDER BY clause is used to sort the records of a table.

Syntax: SELECT column1 , column2, ...

      FROM table_name

      ORDER BY column1, column2, ... ASC | DESC ;

 

Example:

Question 1 Very short- image 5.jpg

Question 1 Very short- image 4.jpg

Remove Ads
Teachoo · Class 12 Explore Class 12

Transcript

This question asked in CBSE SQP-2020 Which clause is used to sort the records of a table? Answer: The ORDER BY clause is used to sort the records of a table. Syntax: SELECT column1, column2, ... FROM table_name ORDER BY column1, column2, ... ASC|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.