A

Admin • 833.24K Points
Coach

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

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

Explanation by: Admin

This question tests your understanding of how the ORDER BY clause works in MySQL.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.