Select statement - Compound column data

[Q_developer]

Hi ,

I have defined a table pv:([] a:10 20 30; b:(`a`b;`c`d`e;`c))

Now I want to write a select statement to give the column a where each b contains `c.

i.e the result should be

a

-

20

30

 

Thanks in advance

 

Regrds,

Saritha

 

 

 

[Kevin Smyth]

select a from pv where `c in'b

> --
> You received this message because you are subscribed to the Google Groups
> "Kdb+ Personal Developers" group.
> To post to this group, send email to personal...@googlegroups.com.
> To unsubscribe from this group, send email to
> personal-kdbpl...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/personal-kdbplus?hl=en.

[Kim Kuen Tang]

select from pv where ('c in) each b

correct the symbol c.

Hth

Kim

Von meinem iPhone gesendet

--

[Attila Vrabecz]

you can hold down ' to get `

Cheers,

  Attila

[Kim Kuen Tang]

Am 01.06.2012 19:13, schrieb Attila Vrabecz:

you can hold down ' to get `

It works on my iphone, thx.

Kim