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.