关于查询结果集的去重? distinct
mysql> select distinct job from emp;
+
| job |
+
| CLERK |
| SALESMAN |
| MANAGER |
| ANALYST |
| PRESIDENT |
+
5 rows in set (0.00 sec)
mysql> select distinct deptno ,job from emp;
+
| deptno | job |
+
| 20 | CLERK |
| 30 | SALESMAN |
| 20 | MANAGER |
| 30 | MANAGER |
| 10 | MANAGER |
| 20 | ANALYST |
| 10 | PRESIDENT |
| 30 | CLERK |
| 10 | CLERK |
+
9 rows in set (0.00 sec)
案例 统计岗位的数量
mysql> select distinct job from emp;
+
| job |
+
| CLERK |
| SALESMAN |
| MANAGER |
| ANALYST |
| PRESIDENT |
+
5 rows in set (0.00 sec)
mysql> select count(distinct job) from emp;
+
| count(distinct job) |
+
| 5 |
+
1 row in set (0.00 sec)