Value

Keyword VALUE

Syntax:

    SELECT VALUE ...

Usually AlaSQL returns array of records (JavaScript objects), but you can modify SELECT statement to return single value from the first line and first column of result recordset:

    var data = [{a:1},{a:2}];
    var res = alasql('SELECT COUNT(*) FROM ?',[data]);
    // returns [{'COUNT(*)':2}]
    var res = alasql('SELECT VALUE COUNT(*) FROM ?',[data]);
    // returns 2

See also: MATRIX, COLUMN, ROW, RECORDSET