【SQL】except 在1张表中,不在另1张表中
declare @table table(id int,name nvarchar(4)) declare @table2 table(id int,name nvarchar(4)) insert into @table values(1,'a') insert into @table values(2,'a') insert into @table values(3,'a') insert into @table values(3,'a') insert into @table values(3,'b') insert into @table values(4,'c') select * from @table except select * from @table2