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.