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.