Parameter List
Syntax
QUERY(data, query,
[headers]
)data
The range or {data}
cell from where data is to be read.
query
The query language that will select and transform the data. For example: "select *"
, "select B,A where B>2"
. Supports:
Selections
with SELECTMathematical operations
with SUM, MIN, MAX, AVERAGE,COUNTConditional clauses
with WHEREAggregations
with GROUP BYSorting
with ORDER BY
[optional] headers
Number corresponds to the rows that are part of the header. Default is 1, meaning that the first row is the header of the table.