Click in order · SQL and MySQL course · Module 10: Transactions and advanced SQL

ROW_NUMBER in each category

Click the elements in order to build a window function with a split and an ordering:

Items to click

  • OVER
  • (PARTITION BY kategoria_id
  • ORDER BY cena DESC)
  • ROW_NUMBER()

You can check the correct answer by solving this task in the CodeWorlds game.