Informatics Practices
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
SQL Queries
1 Like
Answer
{1, 2, 3, 4, 6, 7, 9}
Reason — The ORDER BY clause in SQL sorts the result set based on the specified column(s) in ascending order by default. In the given query, the emp_id column is specified in the ORDER BY clause. Therefore, the query will sort the emp_id values in ascending order.
Answered By
1 Like
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
Which function can you use with ORDER BY clause to specify custom sort order ?
(a) SORT()
(b) CUSTOM()
(c) FIELD()
(d) All of these
By default, ORDER BY clause lists the results in …………… order.
- Descending
- Any
- Same
- Ascending