Put in order · SQL and MySQL course · Module 10: Transactions and advanced SQL
A window with PARTITION BY
Arrange in one line the window clause with a split by category and ordering by price:
Items to put in order
- (PARTITION BY kategoria_id
- ORDER BY cena DESC)
- OVER
You can check the correct answer by solving this task in the CodeWorlds game.