使用 where 子句複製表
CREATE TABLE myschema.tableNew AS (
SELECT *
FROM myschema.tableOld
WHERE column1 = 'myCriteria'
) WITH DATA
CREATE TABLE myschema.tableNew AS (
SELECT *
FROM myschema.tableOld
WHERE column1 = 'myCriteria'
) WITH DATA