Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    5

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

    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.

  2. #2
    Join Date
    Jul 2004
    Location
    So Cal
    Posts
    14
    That's decided by the specific DB system.

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Quote Originally Posted by mihai
    10x in advance
    "10X" = "thanks"? Whatever next...!

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •