max no. of values in WHERE ... IN clause

mihai · #1 (**permalink**) 09-13-04, 05:10

Hi all,

can anyone tell mey what the maximum number of values (if there is any) which can be used in the WHERE ... IN clause?

ex:
.... WHERE ID IN (1, 2, 3 ... , n) ....
what is the maximum number of values which I can put between paranthesis?

10x in advance
mihai.

pantaz · #2 (**permalink**) 09-13-04, 05:24

That's decided by the specific DB system.

andrewst · #3 (**permalink**) 09-13-04, 05:39

Quote:

Originally Posted by mihai

10x in advance

"10X" = "thanks"? Whatever next...!

Pat Phelan · #4 (**permalink**) 09-13-04, 08:08

How many can you put there is one question. How many can you put there and still get an answer while you are young enough to care is a different question. The answer to both questions varies significantly from one query and database engine to another.

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech