22,209
社区成员
发帖
与我相关
我的任务
分享
select * from t1
where id in (
wtih cte ( ... ) select id from cte
)
;wtih cte as ( ... )
select * from t1 where id in ( select distinct id from cte)
;wtih cte AS ( ... ) select * from t1
where id in (
select id from cte
)
应该这样