A

Admin • 833.24K Points
Coach

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 - Option(A)
  • Views: 38
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

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:

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.