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.