Q. If emp_id contain the following set {1, 2, 2, 3, 3, 1}, 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, 1, 2, 2, 3, 3}
Explanation: This question tests your understanding of how the ORDER BY clause works in MySQL.