A

Admin • 833K Points
Coach

Q. If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL statement?
SELECT emp_id
FROM person
ORDER BY emp_id;

  • (A) {1, 2, 3, 4, 6, 7, 9}
  • (B) INSERT
  • (C) {9, 7, 6, 4, 3, 1, 2}
  • (D) None of the mentioned
  • Correct Answer - Option(A)
  • Views: 24
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This question is about understanding how the ORDER BY clause works in MySQL. Let's break it down:

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.