duckplus.functions.aggregate.ordering

Functions

first(→ duckplus.static_typed.expression.TypedExpression)	Call DuckDB function first.
first_filter(...)	Call DuckDB function first with FILTER.

Module Contents

duckplus.functions.aggregate.ordering.first(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function first.

Returns the first value (NULL or non-NULL) from arg. This function is affected by ordering.

Overloads: - main.first(ANY arg) -> ANY

duckplus.functions.aggregate.ordering.first_filter(self: duckplus.static_typed._generated_function_namespaces.AggregateGenericFunctions, predicate: object, *operands: object, order_by: collections.abc.Iterable[object] | object | None = None, within_group: collections.abc.Iterable[object] | object | None = None, partition_by: collections.abc.Iterable[object] | object | None = None, over_order_by: collections.abc.Iterable[object] | object | None = None, frame: str | None = None) → duckplus.static_typed.expression.TypedExpression

Call DuckDB function first with FILTER.

Returns the first value (NULL or non-NULL) from arg. This function is affected by ordering.

Overloads: - main.first(ANY arg) -> ANY