查询单个字段重复数据:
select age from student group by age having count(*)>1;
查询多个字段都重复的数据:
select * from student where (age,nam) in (select age,nam from student group by age,nam having count(*)>1);
删除多个字段都重复的数据:
delete from student where (age,nam) in (select age,nam from student group by age,nam having count(*)>1);