MATRIX

Keyword MATRIX

result modifier for a SELECT

Syntax:

    MATRIX OF SELECT ...

Alternative syntax:

    SELECT MATRIX ...

Usually AlaSQL returns array of records (JavaScript objects), but you can modify SELECT statement to return a matrix (array of arrays) of values from the recordset. Row order is as requested in the select and is not

See also: RECORDSET, VALUE, ROW, COLUMN