Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 3 of 119
Free Preview · 119 of 395 · questions 1–119 of 395 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
- A window function with `ROW_NUMBER()` returns one deterministic latest row per business key while preserving the rest of the row values. Aggregating only `MAX(updated_at)` does not by itself identify the complete winning record, and `DISTINCT` or `LIMIT` does not solve per-key deduplication.