table :student
name nvarchar(20),
sex nvarchar(20),
age int
关键字为:name,age
table:student_temp
解决方法:在表中加一个唯一能标识每行的字段UID uniqueidentifier
SELECT * FROM student_TEMP WHERE UID NOT IN(
select a.UID from student_temp a inner join student b
on a.name=b.name
and a.age=b.age
)