DATABRICKS-SPARK Question 69

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - This is the canonical 'latest per group' pattern: partition by user_id, order by date desc, assign row_number starting at 1, and filter rn = 1. Result: one row per user — the most recent by date.