SQL语句怎么剔除多个条件重复数据

Question

如题所述

Answer 1

如下面的语句可以查询
empid(员工工号)
重复(大于
1
次)的纪录
select
empid,
count(*)
from
employee
group
by
empid
having
count(*)
>
1;
还可以用下面的语句查询重复员工的详细记录
select
*
from
employee
where
empid
in
(select
empid
from
employee
group
by
empid
having
count(*)
>
1)
;