CertLakeDatabricks Cert Prep
← Back to flashcards2 cards left

Data Engineer Professional · Transformation · Window Functions

transformation · 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