-- ANY_VALUE Function: In example below 
-- for idx 2, first value 41 was picked,
-- for idx 4, last value 63 was picked.

SELECT idx ,SUM(val) sum_val  ,ANY_VALUE(val)  any_value_  
FROM (
  SELECT  1 idx, 30 val  FROM DUAL  UNION 
  SELECT  2 idx, 41 val  FROM DUAL  UNION 
  SELECT  2 idx, 90 val  FROM DUAL  UNION 
  SELECT  3 idx, 87 val  FROM DUAL  UNION 
  SELECT  4 idx, 99 val  FROM DUAL  UNION 
  SELECT  4 idx, 63 val  FROM DUAL
)
GROUP BY idx
ORDER BY idx
;