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
πŸ’¬ Discuss
βœ… Correct Answer: (B) {1, 2, 3, 5, 6, 7, 8}
Explanation: This question is about the DISTINCT keyword in MySQL.
Explanation by: Priyanka Tomar
This question is about the DISTINCT keyword in MySQL.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
98
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Priyanka Tomar
Publisher
πŸ“ˆ
96%
Success Rate