SQL Analyst · CTE · ROW_NUMBER
Keep the top two lines per region — software subscriptions
Maintain the top two rows per region from a software subscription dataset designed to control level of detail and variances.
SQL Essentials
Unlock this exercise and continue the path.
Keep the top two lines per region — software subscriptions 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