In

We can use the IN statement to find the values that belong to a specified set. Since this operator allows us to specify more than one value, we can say that it is a shorthand for several OR statements.

Let us prove that by getting the same resulting table as we did by using the OR operators:

1SELECT * 
2FROM Person
3WHERE Country IN (‘USA’, ‘Spain’, ‘Denmark’);

The resulting table is the same as in the ‘OR’ example above.