Put in order · SQL and MySQL course · Module 8: Subqueries

Titles of two categories with UNION ALL

Arrange (top to bottom) the lines of the query joining two lists of titles with the UNION ALL operator:

Items to put in order

  • UNION ALL
  • SELECT tytul FROM ksiazki WHERE kategoria_id = 1
  • SELECT tytul FROM ksiazki WHERE kategoria_id = 2;

You can check the correct answer by solving this task in the CodeWorlds game.