Question

2. What is the significance of "ORDER BY"
in the given query?
SELECT emp_id, frame, iname
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

solve this, could u plz??​

Answer 1

Explanation:

This section presents you various set of Mock Tests related to SQL. You can ... B - select first_name, last name, percentage_of_marks order by ... D - They may modify the data type.