SQL Analyst · CTE · ROW_NUMBER
Keep the two best lines per region — acquisition campaigns
Maintain the top two rows per region from an acquisition campaign dataset designed to control level of detail and variances.
SQL Essentials
Unlock this exercise and continue the path.
Keep the two best lines per region — acquisition campaigns is part of the complete programme: 20 lessons, 180 verifiable exercises and 8 published guided projects.
- Complete content with explained examples
- SQL simulator and expected result
- Detailed answer, common mistakes and challenge