Aggregates Aggregate

first()

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

Arguments & returns

3 overloads

Aggregate

Overload link	`arg`	Returns
#01	`ANY`	`ANY`
#02	`DECIMAL`	`DECIMAL`

Aggregate

Overload link	`col0`	Returns
#03	`T`	`T`

SELECT first(A)
FROM (VALUES
  (10),
  (20),
  (NULL)
) AS sample("A");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.