临时表的创建和使用代码

CREATE GLOBAL TEMPORARY TABLE tmp_emp
ON COMMIT PRESERVE ROWS
AS
SELECT id, name, salary
FROM employee
WHERE dept_id = 10;

COMMIT;

-- 后续仍可查
SELECT COUNT(*) FROM tmp_emp;

drop table tmp_emp;