Question · SQL and MySQL course · Module 10: Transactions and advanced SQL
Why use a CTE
What is the main advantage of using a CTE in complex queries?
Answer options
- The query becomes readable - it reads top to bottom, step by step
- A CTE automatically creates indexes on all columns
- A CTE encrypts the data before sending it to the client
- A CTE lets you omit the SELECT keyword in the query
You can check the correct answer by solving this task in the CodeWorlds game.