Question · SQL and MySQL course · Module 8: Subqueries

Derived table

What is a derived table and what does it require in MySQL?

Answer options

  • A subquery in the FROM clause that acts as a temporary table and must have an alias
  • A permanent table stored on the server's disk
  • An index built automatically for every column
  • A backup copy of the ksiazki table

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