Runs a Google Visualization API Query Language query across data. Sample Usage QUERY(A2:E6,"select avg(A) pivot B") QUERY(A2:E6,F2,FALSE) Syntax QUERY(data, query, [headers]) data - The range of cells to perform the query on. Each column of data can only hold boolean, numeric (including date/time types) or string values. In case of mixed data types in a single column, the majority data type ...
In case of mixed data types in a single column, the majority data type determines the data type of the column for query purposes. Minority data types are considered null values. query - 要執行的查詢作業 (以 Google Visualization API Query Language 寫成)。