Class Count

Namespace

YndigoBlue.Velocity.Functions

Assembly

YndigoBlue.Velocity.dll

Represents the COUNT aggregate function that returns the number of rows or non-null values.

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

Inheritance

object

Function

Count

Implements

IElement

ICheckItem

IDefaultItem

IFilterItem

Remarks

The COUNT function counts rows in a group. When used with a column, it counts non-null values. When used without a column (COUNT(*)), it counts all rows including those with null values. This function is commonly used with GROUP BY to count items per group.

Constructors

Count()

Initializes a new instance of COUNT(*) that counts all rows including nulls.

Count(Column)

Initializes a new instance of COUNT for a specific column, counting non-null values.