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.