Q. What will be the order of sorting in the following MySQL statement?
SELECT emp_id, emp_name
FROM person
ORDER BY emp_id, emp_name;
SELECT emp_id, emp_name
FROM person
ORDER BY emp_id, emp_name;
β
Correct Answer: (A)
Sorting {emp_id, emp_name}
Explanation: This question asks about how data will be sorted in a MySQL query. The ORDER BY clause tells MySQL to sort the results. Let's break it down: