Could you please tell me the differences between
select CustomerId from Customer Where TerritoryId <> All(select TerritoryId from Salesperson)
select CustomerId from Customer where TerritoryId NOT IN (select TerritoryId from Salesperson)
T-SQL – Difference Between <> All and Not In
t-sql
Related Question
- SQL Server 2012 – Difference Between SQL Agent Account NTLM and UPN
- Sql-server – the best way to get all data for a date range, plus the last event just before the range
- SQL Server – Difference Between character_maximum_length and character_octet_length
- T-sql – the difference between Used and Allocated space
- SQL Server – How to Find Differences Between Two Tables
- Sql-server – Get all of the rows involved between tables relationships to delete them
- SQL Server Optimization – Difference Between Filtering in ON Clause vs WHERE Clause
Best Answer
There is no difference in result but there is a bit different semantics.
X [comparison] ALL(set)mean thatsetis empty or the comparison isTRUEfor each entry in the set.X NOT IN (set)means that X does not belong to the set.While
[comparison]is "not equal", both forms are equivalent. But for other comparisons it may be different.