ÇëÎÊÒ»¸ösqlÓï¾ä

ÎÒÏë²é³ösys_employee±íÖÐeidentity×Ö¶ÎÖµÖظ´µÄËùÓÐÐÅÏ¢¡£¡£
select eid ,ename ,eidentity from sys_employee group by eidentity having count(eidentity)>1
ÎÒµÄÓï¾ä²é²»³öÀ´¡£¡£¡£

---

SQL code:
select * from sys_employee a where exists(select 1 from sys_employee where eidentity=a.eidentity and eid<>a.eid)

---

SQL code:
select * from sys_employee t
where eidentity in (select eidentity from sys_employee group by eidentity having count(1) >= 2)

---

select eid ,ename ,eidentity
from sys_employee
inner join (select eidentity from sys_employee group by eidentity having count(eidentity)>1 ) T
on
employee.eidentity  = t.eidentity

---

ÒýÓÃ

SQL codeselect*from sys_employee awhereexists(select1from sys_employeewhere eidentity=a.eidentityand eid<>a.eid)

×ÔÁ´½Ó£¡

---

SQL code:

SELECT * from sys_employee t
WHERE eidentity in
(SELECT eidentity from sys_employee GROUP BY eidentity HAVING COUNT(1) >= 2)