我的Student表是这样的:delete from Student where (StuGrade,StuClass,StuName,StuSex,StuBirthDay) in
(
select StuGrade,StuClass,StuName,StuSex,StuBirthDay from Student where StuGradeID is null and StuClassID is null
group by StuName,StuGrade,StuClass,StuName,StuSex,StuBirthDay having count(*) > 1
) and
StuID not in (select min(StuID) from Student group by StuID,StuName,StuGrade,StuClass,StuName,StuSex,StuBirthDay having count(*)>1)
(
select StuGrade,StuClass,StuName,StuSex,StuBirthDay from Student where StuGradeID is null and StuClassID is null
group by StuName,StuGrade,StuClass,StuName,StuSex,StuBirthDay having count(*) > 1
) and
StuID not in (select min(StuID) from Student group by StuID,StuName,StuGrade,StuClass,StuName,StuSex,StuBirthDay having count(*)>1)
(StuGrade,StuClass,StuName,StuSex,StuBirthDay) in 这句就不对吧,
你要是想这么多条件写,也要写成StuGrade in() and StuClass in () and ...