Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 30 of 79

Database Query using SQL — Question 1

Back to all questions
1
Question

Question 1

What will be the order of the data being sorted after the execution of given SQL query?

SELECT * FROM STUDENT ORDER BY ROLL_NO;
  1. Custom Sort
  2. Descending
  3. Ascending
  4. None of these
Answer

Ascending

Reason — By default, ORDER BY clause sorts the result set in ascending order. Since the query does not include DESC, the data will be sorted in ascending order based on the ROLL_NO column.