-
Notifications
You must be signed in to change notification settings - Fork 665
MATRIX
Mathias Wulff edited this page Oct 31, 2022
·
5 revisions
Result modifier for a SELECT
Suggested syntax:
MATRIX OF SELECT ...
Alternative syntax:
SELECT MATRIX ...
Return data as an array of arrays (one array per row) instead of the default array of javascript objects. Row order is as requested in the select.
You can set query modifier for all SELECTs via:
alasql.options.modifier = 'MATRIX';
© 2014-2024, Andrey Gershun & Mathias Rangel Wulff
Please help improve the documentation by opening a PR on the wiki repo