where not in sql server code example

Example 1: sql not in

SELECT * FROM Customers
WHERE Country NOT IN ('Germany', 'France', 'UK');

Example 2: sql where a or b

-- example
SELECT Id, ProductName, UnitPrice, Package
  FROM Product
 WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'

Example 3: is not in sql server

select * from TableName(nolock) where onlineUser!=('Y')

Tags:

Sql Example

Related