Common Table Expressions
Create a CTE named people and use it in the main query:
WITH people AS (
SELECT 'Mark' AS first_name
)
SELECT *
FROM people;
Press ← or → to navigate between chapters
Press S or / to search in the book
Press ? to show this help
Press Esc to hide this help
Create a CTE named people and use it in the main query:
WITH people AS (
SELECT 'Mark' AS first_name
)
SELECT *
FROM people;