[SQL] Distinct(중복제거)

쉬운 거니 바로 예제를 보도록 하자.

 

select teamcode from center_code_tbl where k_tpo_cd in ('A10100','C10100','C20100')
/

 

 

select distinct teamcode from center_code_tbl where k_tpo_cd in ('A10100','C10100','C20100')
/