有张表student有字段 id,name,se

参考答案:

正确答案：

1 select * from student
group by id,name,sex,birth
having count(name)>1

2 . update test1
set sex =case sex when '男' then '女' else '男' end from student