P

Priyanka Tomar • 35.28K 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: 42
  • Filed under category MySQL

Explanation by: Priyanka Tomar
This question is about the DISTINCT keyword in MySQL.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.


Question analytics