What does the DISTINCT keyword do when used with COUNT?

Question

SQL Fundamentals — Medium

What does the DISTINCT keyword do when used with COUNT?

Accepted Answer

The DISTINCT keyword with COUNT ensures that only unique non-NULL values are counted in the specified column. This means that duplicates are not counted, providing an accurate count of distinct values.