如：
select * from t1
where id in (
wtih cte ( ... ) select id from cte
)
提示语法出错。
------解决思路----------------------
;wtih cte AS ( ... ) select * from t1应该这样
where id in (
select id from cte
)
------解决思路----------------------
语法错误，先声明，再使用。
;wtih cte as ( ... )
select * from t1 where id in ( select distinct id from cte)