Intermediate
SQL
Q55 / 100
What is a "CTE" (Common Table Expression), defined with WITH?
Correct! Well done.
Incorrect.
The correct answer is B) A named temporary result set defined within a query using WITH, which can be referenced like a table within that query, improving readability and enabling recursion
B
Correct Answer
A named temporary result set defined within a query using WITH, which can be referenced like a table within that query, improving readability and enabling recursion
Explanation
A CTE, defined with "WITH name AS (SELECT ...)", creates a temporary named result set scoped to the enclosing query, useful for breaking complex queries into readable steps or writing recursive queries.
Progress
55/100