Put in order · SQL and MySQL course · Module 10: Transactions and advanced SQL
A query with a window function
Arrange the lines of a query with a window function in the correct order (top to bottom):
Items to put in order
- SELECT tytul, cena,
- FROM ksiazki;
- ROW_NUMBER() OVER (ORDER BY cena) AS numer
You can check the correct answer by solving this task in the CodeWorlds game.