稽查表字段重复性

2013-11-08

检查表字段重复性selectcount(*),exam_numfromac_stud_examgroupbyexam_numhavingcount(*)1

检查表字段重复性
select count(*),exam_num from ac_stud_exam group by exam_num having count(*) > 1;