use of not In in sql code example
Example 1: sql not in
SELECT * FROM Customers
WHERE Country NOT IN ('Germany', 'France', 'UK');Example 2: is not in sql server
select * from TableName(nolock) where onlineUser!=('Y')SELECT * FROM Customers
WHERE Country NOT IN ('Germany', 'France', 'UK');select * from TableName(nolock) where onlineUser!=('Y')