CREATE TABLE abc1 AS SELECT * FROM abc WHERE TRY_CAST(col2 AS INT) IS NOT NULL; --- only integers CREATE TABLE abc1 AS SELECT * FROM abc WHERE TRY_CAST(col2 AS FLOAT) IS NOT NULL; --- int and float