with as 创建临时表,解决union all多个时出现内存出错的问题

with
t(content_id, emp_id) as (
VALUES('002', 416)
,('003', 416)
)
SELECT * FROM t;

原文地址:https://www.cnblogs.com/zmc/p/4119328.html