Data Engineer Professional · Data Manipulation· Free preview: up to 10 cards per session

Data Manipulation · Window FunctionsPreview · progress not saved

To keep the latest record per key, why use ROW_NUMBER() OVER (PARTITION BY key ORDER BY ts DESC)=1 over dropDuplicates?

Tap the card, or Space / Enter, to flip · H for a hint