Informatics Practices
Answer
Yes, we can arrange the result set of an SQL query on multiple columns. We should specify the multiple column names in the ORDER BY clause along with the desired sort order.
For example, the following statement will sort the records in the data table first by the section column in ascending order and then by the marks column in descending order.
SELECT * FROM data
ORDER BY section ASC, marks DESC;
Related Questions
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
What will be the order of sorting in the given query?
SELECT emp_id, emp_name FROM person ORDER BY emp_id, emp_name;(a) Firstly on empid and then on empname
(b) Firstly on empname and then on empid
(c) Firstly on empid but not on empname
(d) None of the mentioned
If column emp_id contains the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?
SELECT emp_id FROM person ORDER BY emp_id;(a) {9, 7, 6, 4, 3, 1, 2}
(b) {1, 2, 3, 4, 6, 7, 9}
(c) {2, 1, 4, 3, 7, 9, 6}
(d) None of these
Which function can you use with ORDER BY clause to specify custom sort order ?
(a) SORT()
(b) CUSTOM()
(c) FIELD()
(d) All of these