SQL基础（廿）--- 抑制重复

查询每个员工的部门：

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