Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query.

• 与派生表的不同之处在于,CTE可自引用,还可在同一查询中引用多次。