IN clause in select query

Community Support
1

Hi, I try to run a simple query as follows: select sym_id from sym_table where sym_id in (3, 25, 88) However the in clause doesn’t seem to be working. sym_id is of intdata type. Please advise what the q equivalent of in clause is. Thanks in advance. Nick

2

Date: Tue, 10 Nov 2009 23:56:12 +0800
Message-ID:
Subject: Re: [personal kdb+] IN clause in select query
From: =?GB2312?B?us7OoQ==?= <hewei.com>
To: personal-kdbplus@googlegroups.com
X-Google-Approved: charlie@kx.com via web at 2009-11-10 15:56:42

Ninja,

Could you provide the following info please?

meta sym_table

Cheers,
Wei

2009/11/10 Ninja Li :
>
> Hi,
>
> =A0 I try to run a simple query as follows:
>
> =A0 =A0 select sym_id from sym_table where sym_id in (3, 25, 88)
>
> =A0However the in clause doesn’t seem to be working. sym_id is of int
> data type.
>
> =A0Please advise what the q equivalent of in clause is.
>
> =A0Thanks in advance.
>
> =A0Nick
> >
>

</hewei.com>

3

Wei,It turned out to be an error on my side.Thanks.On Nov 10, 10:56 am, ?? <hewei…> wrote:> Ninja,>> Could you provide the following info please?>> meta sym_table>> Cheers,> Wei>> 2009/11/10 Ninja Li <nickli2…>:>>>>>> > Hi,>> > I try to run a simple query as follows:>> > select sym_id from sym_table where sym_id in (3, 25, 88)>> > However the in clause doesn’t seem to be working. sym_id is of int> > data type.>> > Please advise what the q equivalent of in clause is.>> > Thanks in advance.>> > Nick- Hide quoted text ->> - Show quoted text -</nickli2…></hewei…>

4

nick,if the sym_id datatype is symbol, use the back quote try using select sym_id from sym_table where sym_id in 3 25 88niraj.On Nov 10, 10:39 pm, Ninja Li <nickli2…> wrote:> Wei,>> It turned out to be an error on my side.>> Thanks.>> On Nov 10, 10:56 am, ?? <hewei…> wrote:>> > Ninja,>> > Could you provide the following info please?>> > meta sym_table>> > Cheers,> > Wei>> > 2009/11/10 Ninja Li <nickli2…>:>> > > Hi,>> > > I try to run a simple query as follows:>> > > select sym_id from sym_table where sym_id in (3, 25, 88)>> > > However the in clause doesn’t seem to be working. sym_id is of int> > > data type.>> > > Please advise what the q equivalent of in clause is.>> > > Thanks in advance.>> > > Nick- Hide quoted text ->> > - Show quoted text -</nickli2…></hewei…></nickli2…>