The following example shows the semantics of the recursive CTE structure by returning a hierarchical list of employees, starting with the highest ranking employee, in the Adventure Works Cycles company.

• 以下示例通过返回Adventure Works Cycles公司的雇员的分层列表(从最高级雇员开始)显示递归CTE结构的语义。