A

Admin • 833K Points
Coach

Q. If in Table "account", a column "cust_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 cust_id
FROM account;

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

Explanation by: Admin

This question is about the DISTINCT keyword in MySQL.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.