The IN operator allows you to give multiple values in a WHERE clause. SQL IN operator is used in SQL statements to help reduce the multiple SQL "OR" conditions. It is used in SELECT, INSERT, UPDATE or DELETE statement.
WHERE column_name IN (value1, value2, ...);
WHERE column_name IN (SELECT STATEMENT);
The Following SQL Statement selects all Records from Student Table.
select * from Student
IN Operator Examples
The following SQL statement selects all students that are age in "20", "21"26 and "22" Year.
SELECT * FROM student WHERE age IN (20,21,26,22)