count_distinct

count_distinct — aggregate function to return the count of rows in the specified column that have distinct values

SYNOPSIS

count_distinct (expr)

DESCRIPTION

This function returns the count of rows in the specified column that have distinct values. The expr argument must be a literal column name in the current table, or a simple expression that resolves to a column name.

As of 10.4.4, this function is deprecated but still supported for backward compatibility.

SEE ALSO

This LiveView aggregate function is based on the count_distinct aggregate function in the StreamBase expression language.