Q. If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL statement?
SELECT emp_id
FROM person
ORDER BY emp_id;
SELECT emp_id
FROM person
ORDER BY emp_id;
β
Correct Answer: (A)
{1, 2, 3, 4, 6, 7, 9}
Explanation: This question is about understanding how the ORDER BY clause works in MySQL. Let's break it down: