What is NOT IN Function in SQL?

Programming Language
#1

SQL NOT IN operator is used to filter the result if the values that are mentioned as part of the IN operator is not satisfied. Let’s discuss in detail about SQL NOT IN operator. The SQL Server NOT IN operator is used to replace a group of arguments using the <> (or !=) operator that are combined with an AND. It can make code easier to read and understand for SELECT, UPDATE or DELETE SQL commands. Generally, it will not change performance characteristics.

Syntax:

SELECT
Column

(s)
FROM

table_name
WHERE
Column
NOT
IN
(value1, value2... valueN);

In the syntax above the values that are not satisfied as part of the IN clause will be considered for the result.