请问一个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)