I want to use in where statment filter on many elements (over 100).
For filter on few elements I normally use IN
:
SELECT *
FROM t1
WHERE Product IN ('a', 'b', 'c')
But what if there is over 100 products?
2
I want to use in where statment filter on many elements (over 100).
For filter on few elements I normally use IN
:
SELECT *
FROM t1
WHERE Product IN ('a', 'b', 'c')
But what if there is over 100 products?
2