The distinctcount function is very similar to the count function, but only counts distinct values - duplicates are ignored.

Return Type Number
Aggregates Yes
Flags None


Parameters: distinctcount(value)

Name Type Description
value Dynamic The values which will be counted (Does not count NULL values and duplicates).

Hint: Distinctcount can be called without any parameters which will result in counting the rows.