This website uses cookies to ensure you get the best experience.
Learn more.
A query computes ROW_NUMBER() partitioned by CustomerID ordered by UpdatedAt DESC. Which Snowflake clause can keep row number 1 without an extra nesting level?
Published
- GROUP BY the window result
- QUALIFY
- WHERE on the window alias in the same select
- SAMPLE 1
Comments — 0
Sign in to comment