行者，无疆

摘要： 嗯 多字段查找和删除重复数据。 in 语句在SQL Server 里面不能有多个字段的 所以用inner join 可以 0select * from CET4Grade a inner join(select SJXQ,XQ,StudentID from dbo.CET4Gradegroup by SJXQ,XQ,StudentID having count(*)>1)b on a.SJXQ=b.SJXQ and a.XQ=b.XQ and a.StudentID=b.StudentID删除 嗯 用existsDelete t from dbo.CET4Grade t where ex 阅读全文