SQL Analyst · CTE · ROW_NUMBER

Keep top two lines per region — software subscriptions training scenario

Maintain the top two rows per region from a software subscription dataset designed to control level of detail and variances. You must produce the result, check it on the source data and explain what it allows you to decide in this software subscription.

SQL Analyst

Continue with the right access

“Keep top two lines per region — software subscriptions training scenario” is included from SQL Analyst.

30 free days of SQL Pro on registration, subject to the 32 remaining places. No card or automatic renewal.

Create my Discovery space I already have an account

After signing in, you will return directly to this activity.

How your result is validated