MySQL查询

查询结果关于查询结果集的去重？（distinct关键字去除重复记录）mysql> select distinct job from emp;+———–+| job |+———–+| CLERK || SALESMAN || MANAGER || ANALYST || PRESIDENT |+———–+select ename,distinct job from emp;以上的sql语句是错误的。记住：distinct只能出现在所有字段的最前面。mysql> select distinct deptno,job from emp order by deptno;+——–+———–+| deptno | job |+——–+———–+| 10 | CLERK || 10 | MANAGER || 10 | PRESIDENT || 20 | ANALYST || 20 | CLERK || 20 | MANAGER || 30 | CLERK || ...

Submit