々 々飞翔鸟々 Unregistered / Unconfirmed GUEST, unregistred user! 2008-07-28 #1 table1中有工号和姓名，工号是主键，现在的问题是如何查询出重名的员工记录（不重名的不要），显示字段包括工号和姓名
L levi Unregistered / Unconfirmed GUEST, unregistred user! 2008-07-28 #2 Select * From Table1 Where 姓名 in (Select 姓名 From Table1 Group by 姓名)
A aikede Unregistered / Unconfirmed GUEST, unregistred user! 2008-07-28 #3 select * from table1 where name in (select name from table1 group by name having count(name)>1)
S shadowpj Unregistered / Unconfirmed GUEST, unregistred user! 2008-07-28 #5 select 工号,姓名 from table1 a where (select count(*) from table1 where name=a.name)>1
