Skip to content
Mathias Rangel Wulff edited this page Nov 24, 2015 · 4 revisions

Keyword ROW

Syntax:

    ROW OF SELECT ...

Alternative syntax:

    SELECT ROW ...

Usually AlaSQL returns array of records (JavaScript objects), but you can modify SELECT statement to return an array of values from first row selected.

You can set query modifier for all SELECTs:

    alasql.options.modifier = 'ROW';

See also: VALUE, MATRIX, COLUMN, ROW, RECORDSET

Clone this wiki locally