ANY_VALUE

Learn how to use the ANY_VALUE aggregate function in PlaidCloud Lakehouse. Returns any arbitrary value from a group of rows - with syntax and examples.

Returns any arbitrary value from a group of rows.

Analyze Syntax

func.any_value(get_column(table, 'department'))

Analyze Examples

func.any_value(get_column(table, 'department'))

┌───────┐
│ Sales │
└───────┘

SQL Syntax

ANY_VALUE(<department>)

SQL Examples

SELECT ANY_VALUE(department) FROM employees;

┌───────┐
│ Sales │
└───────┘