select empno,deptno from emp;
7369 20
7499 30
7521 30
7566 20
7654 30
7698 30
7782 10
7788 20
7839 10
7844 30
7876 20
(oracle根据某一列的值去掉重复项)
根据deptno:
select min(empno),deptno group by deptno;
7499 30
7566 20
7369 10
(oralce根据所有项去掉重复项,这点和mysql一致)
select distinct job ,deptno from emp;
JOB DEPTNO
--------- ------
CLERK 10
MANAGER 20
PRESIDENT 10
SALESMAN 30
ANALYST 20
MANAGER 30
MANAGER 10
CLERK 30
CLERK 20
(mysql根据某一列去掉重复项)
跟据name:
select * ,count(distinct name) from testtabel group by name;