例如： sql WITH employees AS (SELECT 1 AS id, '张三' AS name, '销售部' AS department, 5000 AS salary UNION ALL SELECT 2, '李四', '市场部', 6000) SELECT name, department FROM employees; 该查询的结果将返回张三和李四的姓名及对应部门。