Skip to content
Andrey Gershun edited this page May 25, 2015 · 2 revisions

IN

AlaSQL supports IN operatior:

    SELECT a FROM one WHERE b IN (1,2,3)
    SELECT a FROM one WHERE b IN (SELECT b FROM two)
    SELECT a FROM one WHERE b IN ?

In the expression:

    expression IN @(expression)

like:

    10 IN @(?)
    @a IN @(@b)
    20 IN @(@[10,20,30])

See the example in jsFiddle

Clone this wiki locally