Informatics Practices
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
SQL Queries
1 Like
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.
Answered By
2 Likes
Related Questions
Can you arrange the result set of an SQL query on multiple columns ?
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