QUERY
runs SQL-like query on data range · from google sheets · no excel equivalent · sheets: not yet compared
signature
QUERY(data, query, [headers])
returns: array
| argument | required |
|---|---|
| data | required |
| query | required |
| headers | optional |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
| R | S | |
|---|---|---|
| 1 | region | amount |
| 2 | north | 100 |
| 3 | south | 200 |
| 4 | north | 300 |
fx
=QUERY(R1:S4, "select A, B where B > 150") south fx
=QUERY(R1:S4, "select A, B order by B desc limit 2") region