Q. What is the significance of "ORDER BY" in the following MySQL statement?
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id;
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id;
β
Correct Answer: (A)
Data of emp_id will be sorted
Explanation: The "ORDER BY" clause in a MySQL statement is like telling the database to arrange the results in a specific order.