Question 520
A query must label most-recent orders as rank 1 separately for each customer. What function applies?
Explanation
Correct Answer
The scenario calls for partitioned row numbering: ROW_NUMBER() OVER assigns a sequential rank within specified ordering and partitions.
Incorrect Answers
GROUP BY aggregates input rows into groups, commonly reducing result cardinality, rather than satisfying partitioned row numbering.
QUALIFY filters rows based on window-function results in Snowflake SQL, rather than satisfying partitioned row numbering.
HAVING filters groups after aggregation using group-level conditions, rather than satisfying partitioned row numbering.