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
  1. GROUP BY the window result
  2. QUALIFY
  3. WHERE on the window alias in the same select
  4. SAMPLE 1

Comments — 0