Lesson 9.1 · Pro
OVER(): totals without losing rows
Window functions add a group total to every row, so you can compare each row with its group.
In this lesson
- A total on every row with OVER ()
- A group total with PARTITION BY
- Each row's share of its group
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.