A temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement, similar to a derived table in that it is not stored as an object and lasts only for the duration of the query but different from a derived table, as possibly being self-referencing and referenced multiple times in the same query.