Row Number Simulation
Medium
1
71.4% Acceptance
Generate row numbers for each record in the 'Album' table. Importantly, do not use window functions to accomplish this.
Final Columns to Display: AlbumId
, RowNumber
Order By: Results should be ordered by AlbumId
.
To pass this challenge, your query should produce a result set with the columns AlbumId
and RowNumber
, where RowNumber
represents the row number for each corresponding AlbumId
. The result set should be ordered by AlbumId
.