ANY_VALUE
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 │
└───────┘