纠正:select b.姓名 from 员工亲属表 a,员工表 b where a.员工编号=b.员工编号 group by b.姓名 having count(*)>1
yuangong(id,name,age,tele) yuangongjiashu(id,ygid,name)select * from yuangongjiashu where name in (select name from yuangongjiashu group by name having(name)>1)
select 员工编号,姓名 from 员工亲属表 group by 员工编号,姓名 having count(*)>1
from 员工亲属表 a,员工表 b
where a.员工编号=b.员工编号
group by b.姓名
having count(*)>1
yuangongjiashu(id,ygid,name)select * from yuangongjiashu where name in (select name from yuangongjiashu group by name having(name)>1)
from 员工亲属表
group by 员工编号,姓名
having count(*)>1