Search notes:

Oracle SQL: ANY_VALUE

The ANY_VALUE(…) «aggregate function» evaluates to the first non-null value encountered in a group of a select statement using the group by clause.

select
   grp_1,
   grp_2,
   max(val_1),
   ANY_VALUE(val_2)
from
   tab
group by
   grp_1,
   grp_2

Oracle SQL: ANY_VALUE

See also