What is the significance of "ORDER BY emp_id DESC" in the following MySQL command? SELECT emp_id, fname, lname FROM person ORDER BY emp_id DESC;

Q. What is the significance of "ORDER BY emp_id DESC" in the following MySQL command?
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id DESC;

(A) Data of emp_id will be sorted in descending order
(B) reads
(C) Data of emp_id will be sorted in either ascending or descending order
(D) All of the mentioned

✅ Correct Answer: (A) Data of emp_id will be sorted in descending order

Explanation: The code you see uses "ORDER BY emp_id DESC" to arrange the data. This part tells MySQL to sort the results of the query. Let's break down what it means:

Published by Praveen Singh ⭐ 36.81K Points at 22-Mar-2025 12:41 pm in MySQL

📊 Question Analytics

👁️

127

Total Visits

📽️

2 y ago

Published

🎖️

Praveen Singh

Publisher

📈

95%

Success Rate

Q. What is the significance of "ORDER BY emp_id DESC" in the following MySQL command?
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id DESC;

Explanation by: Praveen Singh

💬 Discussion

📊 Question Analytics

Q. What is the significance of "ORDER BY emp_id DESC" in the following MySQL command? SELECT emp_id, fname, lname FROM person ORDER BY emp_id DESC;

Explanation by: Praveen Singh

💬 Discussion

📊 Question Analytics

Q. What is the significance of "ORDER BY emp_id DESC" in the following MySQL command?
SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id DESC;