PostgreSQL 18 reference · Aggregate Functions

PostgreSQL ANY_VALUE() Function

Return an arbitrary non-NULL value from a group. Useful for columns you know are the same within each group.

PostgreSQL 18 Since 16

Create a free account to save this page, take notes and track your progress. Sign in

Syntax

any_value(expression)

Parameters

Parameter	Description
`expression`	A column or expression.

Return value

One of the group's values.

Examples

A column that's the same per group

SELECT o.customer_id, any_value(c.name) AS name, count(*) AS orders
FROM orders AS o JOIN customers AS c USING (customer_id)
GROUP BY o.customer_id
ORDER BY orders DESC, o.customer_id
LIMIT 3;

Output

 customer_id |     name     | orders
-------------+--------------+--------
           1 | Ada Lovelace |      3
           2 | Alan Turing  |      2
           3 | Grace Hopper |      2
(3 rows)

Run this on your computer — see “Get Started” for setup.

NULLs are skipped

SELECT any_value(x) IS NOT NULL AS found FROM (VALUES (NULL), (5)) AS t(x);