• A CTE can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query.
This image has an empty alt attribute; its file name is image-6.png
This image has an empty alt attribute; its file name is image-5.png

Resources