查询每个员工的部门:
mysql> select fdepartment from t_employee;
+---------------+
| fdepartment |
+---------------+
| Development |
| Development |
| HumanResource |
| HumanResource |
| InfoTech |
| InfoTech |
| Sales |
| Sales |
| Sales |
+---------------+
9 rows in set
去除重复的部门:
mysql> select distinct fdepartment from t_employee;
+---------------+
| fdepartment |
+---------------+
| Development |
| HumanResource |
| InfoTech |
| Sales |
+---------------+
4 rows in set
注:DISTINCT是对整个结果集进行数据重复抑制的,而不是针对每一个列
例如:
mysql> select distinct fsubcompany, fdepartment from t_employee;
+-------------+---------------+
| fsubcompany | fdepartment |
+-------------+---------------+
| Beijing | Development |
| ShenZhen | Development |
| Beijing | HumanResource |
| Beijing | InfoTech |
| ShenZhen | InfoTech |
| Beijing | Sales |
| ShenZhen | Sales |
+-------------+---------------+
7 rows in set