ARBITRARY

ARBITRARY chooses one value out of a set of values. ARBITRARY is useful for silencing warnings about values neither grouped by or aggregated over.

Parameter	Type	Description
`value`	any	the values selected from

Returns: any

Example

query:

SELECT ARBITRARY(close_value)
  FROM sales_pipeline

siyeh/sql-crm-example-data Run query Copy code

result:

arbitrary
1054