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.

• CTE与派生表类似,具体表现在不存储为对象,并且只在查询期间有效。