Aggregates Aggregate

first_value()

Arguments & returns

Aggregate

Overload link	`col0`	Returns
#01	`T`	`T`

SELECT fruit, first_value(fruit) OVER (ORDER BY quantity DESC) AS best_seller
FROM (VALUES ('apples', 12), ('pears', 8)) AS data(fruit, quantity);

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

SELECT FIRST_VALUE(sample_col, TRUE)

In DuckDB

SELECT FIRST_VALUE(sample_col IGNORE NULLS)

SELECT ANY_VALUE(col, true), FIRST(col, true), FIRST_VALUE(col, true) OVER ()

In DuckDB

SELECT ANY_VALUE(col), ANY_VALUE(col), FIRST_VALUE(col IGNORE NULLS) OVER ()