# COUNT
## Definition(s)
### [[Nexus - Google Analytics Certificate Course#5.3 Google Analytics - 5 Analyze - Module 3 - Aggregate Data for Analysis Aggregate Data for Analysis|Google Analytics Certificate]]
#### Subcontext [[SQL Function]]
>[! Definition] COUNT DISTINCT
>A SQL function that only returns the distinct values in a specified range
## Examples
```SQL
SELECT
COUNT(DISTINCT(orders))
FROM
db.table
```
## Related
### Spreadsheets
[[COUNTIF]]
## Resources
[W3 School's COUNT overview](http://www-db.deis.unibo.it/courses/TW/DOCS/w3schools/sql/sql_func_count.asp.html)
## Flashcards
The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/)