is not in sql server

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

1Returns true if a record DOESN’T meet the condition.
2Example: Returns true if the user’s first_name doesn’t end with ‘son’.
3SELECT * FROM users
4WHERE first_name NOT LIKE '%son';

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

1
2(NOT) operator excluding given
3For example:
4Select last_name, job_id From Employees
5Where "Not" job_id = 'ABC';
6