SQL Server Nested CTE with examples

we can say that CTE is a named temporary set of rows similar to subqueries. Like subqueries, you can't put one CTE definition inside another CTE definition.