πŸ“Š MySQL
Q. What is the significance of "ORDER BY" in the following MySQL statement?
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id;
  • (A) Data of emp_id will be sorted
  • (B) Data of emp_id will be sorted in descending order
  • (C) Data of emp_id will be sorted in ascending order
  • (D) All of the mentioned
πŸ’¬ Discuss
βœ… 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.

Explanation by: Vinay
The "ORDER BY" clause in a MySQL statement is like telling the database to arrange the results in a specific order.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
77
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Vinay
Publisher
πŸ“ˆ
90%
Success Rate