not operator sql code example

Example 1: sql not in

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

Example 2: sql not

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

Tags:

Sql Example

Related