SELECT * INTO #tablename FROM table WHERE column1='abc' ORDER BY column1 desc; 테이블의 구조만 복사 SELECT * INTO my_new_table FROM old_table WHERE 1= 2; 테이블에 데이터의 삽입 INSERT INTO my_new_table SELECT * FROM old_table WHERE ...; [출처] [SQL] CREATE TABLE AS( SELECT...)|작성자 monad