Skip to content
agershun edited this page Dec 28, 2014 · 2 revisions

SELECT WHERE

Expression

    var res = alasql('SELECT * FROM City WHERE Population > 1000000');

WHERE EXIST() / NOT EXIST()

    var res = alasql('SELECT * FROM City WHERE \
            EXIST(SELECT * FROM Capital WHERE City.Name = Capital.Name)');
Clone this wiki locally