Class CountDistinct

Namespace

YndigoBlue.Velocity.Functions

Assembly

YndigoBlue.Velocity.dll

Represents the COUNT(DISTINCT) aggregate function that returns the number of unique non-null values.

public class CountDistinct : Function, IElement, ICheckItem, IDefaultItem, IFilterItem

Inheritance

object

Function

CountDistinct

Implements

IElement

ICheckItem

IDefaultItem

IFilterItem

Remarks

The COUNT DISTINCT function counts unique values in a column, excluding duplicates and null values. This is useful for determining the number of distinct categories, unique identifiers, or different values in a dataset. Often used with GROUP BY to count distinct items per group.

Constructors

CountDistinct(Column)

Initializes a new instance of COUNT(DISTINCT) for a specific column.