DISTINCT 값들을 INSERT 하기

1 개요

DISTINCT 값들을 INSERT 하기

INSERT 테이블2(컬럼명) SELECT DISTINCT 컬럼명 FROM 테이블1

INSERT ids(id) SELECT DISTINCT id FROM employees

INSERT names(name) SELECT DISTINCT name FROM employees

2 같이 보기

• DISTINCT
• INSERT

3 참고

• https://stackoverflow.com/questions/18599149/insert-distinct-values-from-one-table-into-another-table