K kongfei Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-09 #1 如果记录中的某两个字段的内容一样，两个记录视为重复
J jixiaoyu Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-09 #2 利用group by 和having可以满足你的要求
K kongfei Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-09 #3 可是这时候我只能看group 的字段内容，我想看其它的怎么办？
沧 沧海一声笑 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-09 #4 怎么又是你 select 人名,生日 from yourTableName where 人名 in( select 人名 from yourTableName group by 人名,生日 having count(*) > 1) and 生日in( select 生日 from yourTableName group by 人名,生日 having count(*) > 1)
怎么又是你 select 人名,生日 from yourTableName where 人名 in( select 人名 from yourTableName group by 人名,生日 having count(*) > 1) and 生日in( select 生日 from yourTableName group by 人名,生日 having count(*) > 1)
