Q. What is the significance of "ORDER BY emp_id ASC" in the following MySQL command?
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id ASC;
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id ASC;
β
Correct Answer: (B)
Data of emp_id will be sorted in ascending order
Explanation: This MySQL command selects the employee ID (emp_id), first name (fname), and last name (lname) from the table called person.