A

Admin • 831.35K Points
Coach

Q. If in Table "employee", a column "emp_id" consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?
SELECT DISTINICT emp_id
FROM employee;

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

Explanation by: Admin
This question is about how MySQL's DISTINCT keyword works.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.