示例代码如下:
;with a as(select * from table_a),b as (select * from a where id in(3,4,5))select * from b
记得一定要有逗号间隔开两个查询,最后一个查询前是没有逗号的