1.准备
CREATE DATABASE mahaiwuji;USE mahaiwuji;CREATE TABLE emp( empno INT PRIMARY KEY, ename VARCHAR(10), sal INT, deptno INT );INSERT INTO emp VALUES (1,'smith',300,10);INSERT INTO emp VALUES (2,'allen',NULL,10);INSERT INTO emp VALUES (3,'ward',NULL,20);INSERT INTO emp VALUES (4,'jones',NULL,10);INSERT INTO emp VALUES (5,'martin',NULL,30);INSERT INTO emp VALUES (6,'blake',200,20);INSERT INTO emp VALUES (7,'clark',0,30);
![13bb23cd7c3e0f8409b2317f44baa745.png](https://img-blog.csdnimg.cn/img_convert/13bb23cd7c3e0f8409b2317f44baa745.png)
2.使用
实际应用中,出于对数据的分析需求,有时需要去除查询记录中重复的数据。
过滤掉重复的deptno
SELECT DISTINCT deptno FROM emp;
![0ee7c2e481ad990610f9e65147c1fed3.png](https://img-blog.csdnimg.cn/img_convert/0ee7c2e481ad990610f9e65147c1fed3.png)
过滤掉重复的sal
-- DISTINCT可以去掉多余的NULL,或者说如果有多个NULL,只保留一个 -- 0不是NULL SELECT DISTINCT sal FROM emp;
![cfa6986795f134eabc293c008655cd93.png](https://img-blog.csdnimg.cn/img_convert/cfa6986795f134eabc293c008655cd93.png)
把sal和deptno的组合进行过滤
SELECT DISTINCT sal,deptno FROM emp;
![54574e5ab0675b3871e6677661f80a3c.png](https://img-blog.csdnimg.cn/img_convert/54574e5ab0675b3871e6677661f80a3c.png)