πŸ“Š MySQL
Q. What does this query do?
Code:
SELECT COUNT(DISTINCT country) FROM customers;
  • (A) Counts total countries
  • (B) Counts all customers
  • (C) Counts unique countries
  • (D) Counts duplicate countries
πŸ’¬ Discuss
βœ… Correct Answer: (C) Counts unique countries

Explanation: `COUNT(DISTINCT column)` counts only unique values in the column.

Explanation by: Mr. Dubey
`COUNT(DISTINCT column)` counts only unique values in the column.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
68
Total Visits
πŸ“½οΈ
9 mo ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
83%
Success Rate