select name,count(name) from a goup by name having count(name)>1
declare @sex select @sex = sex from a where XXX update b set sex = @sex where XXX
测试通过: select test1 from test group by test1 having count(test1)>1
XXX是社么意思?我想让b表中的记录自动到a表中去查找记录并更新是自动批量更新!!!
可以通过数据库里面的两个表的SEX字段建立关系,(级联更新)
请问dulkernetbug(小黑小白) :
select name from a goup by name having count(1)>0 --只列出了有那些姓名被重复,并没有把重复姓名的纪录列出来必须是: select b.myname from table1 as b , ( select myname from table1 group by myname having count(myname)>1 ) as a where a.myname = b.myname
或者having count(*)>1
select @sex = sex from a where XXX
update b set sex = @sex where XXX
select test1 from test group by test1 having count(test1)>1
--只列出了有那些姓名被重复,并没有把重复姓名的纪录列出来必须是:
select b.myname from table1 as b ,
( select myname from table1 group by myname having count(myname)>1 ) as a
where a.myname = b.myname