: Re: [sqlite] Number of elements in IN clause
"Samuel R. Neff" <[EMAIL PROTECTED]> wrote:
> I don't think it is standard SQL. At the very least, it doesn't work in
> MSSQL. Standard is
>
> SELECT * FROM maintable WHERE key IN (select x from stuff);
>
>
s notation, but it does make sense. It would
be nice if it matched on field name, that way the same syntax could be
used in both cases.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January 28, 2008 9:20 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqli
"Samuel R. Neff" <[EMAIL PROTECTED]> wrote:
> I don't think it is standard SQL. At the very least, it doesn't work in
> MSSQL. Standard is
>
> SELECT * FROM maintable WHERE key IN (select x from stuff);
>
> SQLite shortened version is much nicer.. wish it was standard.
>
SQLite also
ect: Re: [sqlite] Number of elements in IN clause
Felix Radensky <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is there any limitation on the number of elements in IN clause ?
> Can one have, e.g. thousands of elements ? Also, can having to many
> elements become inefficient at some
Subject: RE: [sqlite] Number of elements in IN clause
>SELECT * FROM maintable WHERE key IN stuff;
Thanks for that tip. Didn't know you could do that.
Can't remember this as standard SQL.
RBS
-
To unsubscribe, s
Re: [sqlite] Number of elements in IN clause
Felix Radensky <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is there any limitation on the number of elements in IN clause ?
> Can one have, e.g. thousands of elements ? Also, can having
> to many elements become inefficient at some point a
Felix Radensky <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is there any limitation on the number of elements in IN clause ?
> Can one have, e.g. thousands of elements ? Also, can having
> to many elements become inefficient at some point and one
> has to use some other technique, i.e. comparing
7 matches
Mail list logo