Stores the result of a query in a temporary table using an alias.
WITH clause is also known as common table expression (CTE) and subquery factoring.
WITH temporary_name AS (SELECT *FROM table_name)SELECT *FROM temporary_nameWHERE condition;
You can also define multiple temporary tables using a comma and with one instance of the
The given query will store the result of
SELECT * FROM movies into a temporary table named
WITH temporary_movies AS (SELECT *FROM movies)SELECT *FROM temporary_moviesWHERE year BETWEEN 2000 AND 2020;
- Anonymous contributors
Learn SQL on Codecademy
- Anonymous contributorsAnonymous contributors