6] 프로그래머스 중복 제거하기

IT/SQL

6] 프로그래머스 중복 제거하기

깻잎쌈 2020. 11. 4. 23:02

SELECT COUNT(DISTINCT NAME) 
FROM ANIMAL_INS;

www.w3schools.com/sql/sql_distinct.asp

SQL SELECT DISTINCT Statement

SQL SELECT DISTINCT Statement The SQL SELECT DISTINCT Statement The SELECT DISTINCT statement is used to return only distinct (different) values. Inside a table, a column often contains many duplicate values; and sometimes you only want to list the differe