IN statement

Question

what does IN statement does, can someone explain with example?

Answer 1

IN tells you whether the given variable is part of a given subset.

SELECT *
FROM suppliers
WHERE supplier_name IN ('Microsoft', 'Oracle', 'Flowers Foods');

It is a short cut and the same as.

SELECT *
FROM suppliers
WHERE supplier_name = 'Microsoft'
OR supplier_name = 'Oracle'
OR supplier_name = 'Flowers Foods';

https://www.techonthenet.com/sql/in.php

Answer 2

Thankyou sneeze