IN and NOT IN Operators in SQL

For Complete YouTube Video: Click Here

In this class, we will understand IN and NOT IN Operators in SQL.

We have already discussed the concepts of IS NULL and IS NOT NULL.

Table of Contents

Before understanding IN and NOT IN Operators in SQL, we will understand the list of values testing operators.

In our previous classes, we have understood the single value testing operator.

Operators which can Test a List of values.

These operators are used to test from a list of values.

There are four types of operators.

In this class, we will try to understand IN and NOT IN Operators in SQL.

To understand this, we will consider the table of values given below.

From the above table, we would like to display the details of the students whose salary is equal to 100 or 300 or 500.

The query is as shown below.

SELECT * FROM students WHERE salary IN (100, 300, 500);

From the above table and query, we can select the students whose salary is 100 or 300 or 500.

The output of the query is as shown below.

Similar to the above, we can also select the rows NOT IN the given list of values.

NOT IN is just the opposite of the IN operator.

The query with the use of NOT IN is as shown below.

SELECT * FROM students WHERE salary IN (100, 300, 500);

The output of the query is as shown below.