Get the First or Last Value in a Group Using Group By in SQL

Sample code in PostgreSQL

SELECT
  account,
  MAX(ARRAY[id, (data->'credit')::int])
    FILTER (WHERE type = 'credit_set'))
FROM
  event
GROUP BY
  account;

ref: https://hakibenita.com/sql-group-by-first-last-value

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s