SQL In Operatior

Why use the IN operator? The advantages are

• When you are working with long lists of valid options, the IN operator syntax is far cleaner and easier to read.

• The order of evaluation is easier to manage when IN is used (as there will be fewer operators used).

• IN operators almost always execute more quickly than lists of OR operators.

• The biggest advantage of IN is that the IN operator can contain another SELECT statement, enabling you to build highly dynamic WHERE clauses.