Lesson 10.4 · Pro
FIRST_VALUE and LAST_VALUE
Put a group's first or last value on every row, and avoid the LAST_VALUE trap.
In this lesson
- FIRST_VALUE
- The LAST_VALUE trap
- Compare each row with the first one
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.