Address BY column in query

Question

How to access BY column in spreadsheet using query?

Background story: this query:

=query(A1:BZ10,"select A,B,C where (BY> 1))",1)

causes unable to parse error:

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "by" "BY "" at line 2, column 16. Was expecting one of: "true" ... "false" ...

Reason for parse error is because BY is interpreted as BY from group by etc.

`=QUERY(A1:BZ10, "select A,B,C where \`BY\` > 1", 1)` – player0 Jan 28 '19 at 20:26 — player0, Jan 28 '19 at 20:26

player0 · Accepted Answer · 2019-01-28T20:38:24.517

1

use ` instead of `()` like:

=QUERY(data!B2:CL, "select B, C, D, E, F, G, H, I, J, `BY`, BZ, CA, BA 
                    where J = 'Industry Certification'", 0)

edited Jan 28 '19 at 20:38

answered Jan 28 '19 at 20:23

player0

124,011
12
67
124

Address BY column in query

1 Answers1

use ` instead of () like:

use ` instead of `()` like: