πŸ“Š MySQL
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;
  • (A) Data of emp_id will be sorted in descending order
  • (B) Data of emp_id will be sorted in ascending order
  • (C) Data of emp_id will be sorted in either ascending or descending order
  • (D) All of the mentioned
πŸ’¬ Discuss
βœ… 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.

Explanation by: Priyanka Tomar
This MySQL command selects the employee ID (emp_id), first name (fname), and last name (lname) from the table called person.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
76
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Priyanka Tomar
Publisher
πŸ“ˆ
89%
Success Rate