[Oracle SQL] SELECT 실습_ DISTINCT

[Oracle SQL] SELECT 실습_ DISTINCT 

I DISTINCT

▶ 중복 제거

1. UNIQUE는 ORACLE 고유 SQL   v.   DISTINCT는 ANSI-SQL 표준

---

SELECT UNIQUE JOB FROM EMP;

---

---

SELECT DISTINCT JOB FROM EMP;

---

2. DISTINCT : NULL

---

SELECT DISTINCT COMM FROM EMP;

---