The SQL IN Operator is used to check to specified multiple matche values in a WHERE or HAVING clause, you can also use AND or OR operator for multiple WHERE or HAVING condition.

• The IN Operator is a logical operator then the all values must have the same type of the column.
• IN Operator return the value 1 when the search value present OTHERWISE it return 0 (Zero).

IN Operator Syntax

SELECT  column_name(s)
FROM table_name
WHERE column_name IN (value_1, value_2, value_3, .....);

Other IN Operator Syntax

SELECT  column_name(s)
FROM table_name
WHERE column_name IN (SELECT Statement);

EXAMPLE: IN Operator

Student Table

A table of student records, the name of table is "Student", and the name of columns are [ROLL_NO, STUDENT_NAME, ADDRESS, MOBILE_NO, AGE, and BRANCH]:

IN Operator

SELECT  *
FROM Student
WHERE BRANCH IN (IT, CSE);

Result Look Like

NOT IN Operator

SELECT  *
FROM Student
WHERE BRANCH NOT IN (IT, CSE);

Result Look Like