Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 9 of 90

Querying Using SQL — Question 2

Back to all questions
2
Question

Question 2

What is the significance of "ORDER BY" in the given query?

SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id;

(a) Data of table person on the basis of column emp_id will be sorted in descending order

(b) Data of table person on the basis of column emp_id will be sorted in ascending order

(c) Only data of column emp_id will be sorted in descending order

(d) Only data of column emp_id will be sorted in ascending order

Answer

Data of table person on the basis of column emp_id will be sorted in ascending order

Reason — The significance of the ORDER BY clause in the given query is to sort the result set based on the values in the emp_id column in ascending order by default.