select e.编号,e.姓名,t.num from emp e,(select count(*) num ,姓名 from emp group by 姓名 ) t where e.姓名=t.姓名
select e.编号,e.姓名,t.num from emp e,(select count(*) num ,姓名 from emp group by 姓名 ) t where e.姓名=t.姓名 and t.num >1
select name ,count(*) as totqty from tab group by name having count(*)>1
select a.* from table a,table b where b.姓名=a.姓名 and b.编号 <>a.编号 SELECT R.编号, l.姓名 FROM table L JOIN table R ON L.姓名 = R.姓名 GROUP BY R.编号, l.姓名 HAVING COUNT(*) > 1
SELECT COUNT(*) AS 个数, a.name FROM test1 a INNER JOIN test1 b ON a.姓名 = b.姓名 AND a.[编号] <> b.[编号] GROUP BY a.姓名
SELECT COUNT(*) AS 个数, a.name FROM emp a INNER JOIN emp b ON a.姓名 = b.姓名 AND a.[编号] <> b.[编号] GROUP BY a.姓名
from table a,table b
where b.姓名=a.姓名
and b.编号 <>a.编号
SELECT R.编号, l.姓名
FROM table L
JOIN table R
ON L.姓名 = R.姓名
GROUP BY R.编号, l.姓名
HAVING COUNT(*) > 1
FROM test1 a INNER JOIN
test1 b ON a.姓名 = b.姓名 AND a.[编号] <> b.[编号]
GROUP BY a.姓名
FROM emp a INNER JOIN
emp b ON a.姓名 = b.姓名 AND a.[编号] <> b.[编号]
GROUP BY a.姓名