CTE查询是为了简化子查询的复杂用法。 ```sql with a as (select * from employee), -- 查询employee表的结果作为表a b as (select * from a) select * from b where name='Will'; ```