我想查出sys_employee表中eidentity字段值重复的所有信息。。
select eid ,ename ,eidentity from sys_employee group by eidentity having count(eidentity)>1
我的语句查不出来
select eid ,ename ,eidentity from sys_employee group by eidentity having count(eidentity)>1
我的语句查不出来
where eidentity in (select eidentity from sys_employee group by eidentity having count(1) >= 2)
from sys_employee
inner join (select eidentity from sys_employee group by eidentity having count(eidentity)>1 ) T
on
employee.eidentity = t.eidentity
SELECT * FROM sys_employee t
WHERE eidentity in
(SELECT eidentity FROM sys_employee GROUP BY eidentity HAVING COUNT(1) >= 2)