Question · SQL and MySQL course · Module 10: Transactions and advanced SQL
CTE versus a view
How does a CTE differ from a view?
Answer options
- A CTE lives for just one query, while a view is saved in the database permanently
- A CTE is faster because it works only on a copy of the data
- A CTE can only be used with INSERT, and a view only with SELECT
- There is no difference - they are two words for the same thing
You can check the correct answer by solving this task in the CodeWorlds game.