medium10 pts · first answer countsdata-warehousingsqlwindow-functions

Keeping the latest row per customer

A raw table has several rows per customer_id from repeated loads. You want only the most recent row per customer, by updated_at. Which approach in Snowflake or BigQuery does this?

A.DISTINCT on every columnB.GROUP BY customer_id with SELECT *C.QUALIFY ROW_NUMBER() per customer, newest first, = 1D.MAX(updated_at) with SELECT * and no GROUP BY

Discussion 0

Join free to post in the discussion.

Keeping the latest row per customer

Discussion 0

Related questions