CODEWITHSUNDEEP
google-sheetsformulasgoogle-query-language
Max Makhrov
Max Makhrov

Reputation: 18717

Skipping for Query

Recently I've found special word "skipping" which works in query. I accidentally found out about it. This formula works:

=QUERY(A1:A11,"select A skipping 2")

It skips 1 row, gives me rows 1, 3, 5, 7... and so on. Skipping 1 returns all the rows, skipping 3 returns 1, 4, 7, 10...

enter image description here

I wonder if there any expressions in google-sheets query, that are not listed in Query Language Reference. And if someone else used or found "skipping" for queries.

Upvotes: 10

Views: 4556

Answers (1)

Chris Hick
Chris Hick

Reputation: 3094

It is visible on the message you receive for a QUERY syntax error:

"Unable to parse query string for Function QUERY parameter 2: PARSE_ERROREncountered "(" at line 1, column 41. Was expecting one of: <EOF> "where" ... "group" ... "pivot" ... "order" ..."skipping" ... "limit" ... "offset" ... "label" ... "format" ... "options" ... "," ... "*" ... "+" ... "-" ... "/" ... "%" ..."

Sadly I think that means there aren't any other hidden clauses for us to find since the others are all mentioned on the guidance page.

Upvotes: 5

Related Questions