IN Operator –
The IN operator is used to specify a range of conditions, any of which can be matched. IN takes a comma-delimited list of valid values, all enclosed within parentheses.
Syntax of IN –
SELECT column1, column2 FROM table_name WHERE column1 IN (value1, value2)
Employee Table –
Let’s say you want to select all the employee who are either Manager or Analyst.
SELECT * FROM emp WHERE JOB IN ('MANAGER', 'ANALYST');