Put in order · SQL and MySQL course · Module 10: Transactions and advanced SQL
Numbering from the most expensive book
Arrange in one line a window function that numbers rows by price descending:
Items to put in order
- OVER
- (ORDER BY cena DESC)
- AS numer
- ROW_NUMBER()
You can check the correct answer by solving this task in the CodeWorlds game.