The ANY_VALUE(…) Aggregate Function

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

The ANY_VALUE(…) Aggregate Function: New in SQL:2023 — and a better feature from 1999 a ⚡Might return null even if there are non- null values b ⚡ Not an aggregate function c Without filter clause d Not as window function ( over clause) The aggregate function any_value takes a non- null value from a group of rows. SELECT product_id , ANY_VALUE(order_id) AS example_order_id FROM order_lines GROUP BY…

Read on modern-sql.com ↗