EXCEPT operator vs NOT IN

18 votes

3 answers

44893 views

sql-server sql-server-2008-r2 sql-server-2005 operator except

                          The EXCEPT operator was introduced in SQL Server 2005 but what is the difference between NOT IN and EXCEPT ?

Does it do the same? I would like a simple explanation with an example.

Asked by Heisenberg (1505 rep)

Nov 26, 2014, 10:19 AM
Last activity: Aug 18, 2019, 09:23 AM

EXCEPT operator vs NOT IN

Related Questions