Row numbers with partitioning
If you run ROW_NUMBER() OVER (PARTITION BY Year ORDER BY Medals DESC)
on the following table, what row number would the 2008 Iranian record have?
| Year | Country | Medals |
|------|---------|--------|
| 2004 | IRN | 32 |
| 2004 | LBN | 17 |
| 2004 | KSA | 4 |
| 2008 | IRQ | 29 |
| 2008 | IRN | 27 |
| 2008 | UAE | 12 |
This exercise is part of the course
PostgreSQL Summary Stats and Window Functions
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
