Question · SQL and MySQL course · Module 8: Subqueries
Missing derived table alias
What happens in MySQL if a derived table in the FROM clause is not given an alias?
Answer options
- The query works but returns only the first row
- MySQL automatically removes the derived table
- An alias is never needed in MySQL
- The query reports an error - MySQL requires an alias for a derived table
You can check the correct answer by solving this task in the CodeWorlds game.