你即將離開本站

並前往https://hakibenita.com/sql-group-by-first-last-value

How to Get the First or Last Value in a Group Using Group By ...

db=# SELECT account, ((ARRAY_AGG(data ORDER BY happened_at DESC) FILTER (WHERE type = 'credit_set'))[1] -> 'credit')::int AS credit FROM ...

確定！ 回上一頁

查詢 「Athena array_agg」的人也找了：

  1. Athena array_agg
    2.
  2. Athena json_extract
    3.
  3. Array_agg order by athena
    4.
  4. Athena filter
    5.
  5. Athena Presto
    6.
  6. Athena for loop
    7.
  7. Athena engine
    8.
  8. Athena ARRAY
    9.