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

    Unanswered: max no. of values in WHERE ... IN clause (JDBC)

    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.
    PS. I'm using JDBC to execute my SQL queries
    Last edited by mihai; 09-13-04 at 06:32.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I do not think that there is a limit to the number of expressions you can have. You do have a limit on the number of characters that an SQL statement can be, and that is 65,535 for V8.1 LUW. This will limit the number of expressions you can use.

    Do not forget, you can use SELECT ... WHERE .. IN (<full-select>) the full-select can have any number of rows.

    HTH

    Andy

Posting Permissions

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