无法解析功能查询参数2：PARSE_ERROR： ＆quot by＆quot ＆quot“ by”“”在第1行，第47列
当我尝试使用创建此功能时。 = query（xxxxxxxxxx！$ a $ 1：$ 1：$ cj，“ select bl，bm，bn，bk，bk，bp，bq，bq，br，br，br，b b b b b b b b b b bu bu，b b b b bs bs，bs by by b b b z，bz，bz，bz，bw，cb，cb，cc，cc ,, CD，CA，CF，CG，CH，CE 其中a＆gt;日期'2022-03-21'”）我会收到以下错误。
无法解析函数查询参数2：PARSE_ERROR：遇到“”“”。 “ true” ...“ false” ...“ date” ...“ timeofday” ...“ dateTime” ...“ Timestamp” ...“ Min” ...“ Max” ...“ Max” ...” AVG “ ...” count“ ...” sum“ ...” no_values“ ...” no_format“ ...”是“ ...” null“ ...” Year'...“ ...”月。 。 “结束” ...“匹配” ...“……”现在“ ...” “ ...” ...“ min” ...“ max” ...“ count” ...“ AVG” ...“ sum” ...“ ...”年...“ ...”月...“ day” .. 。季度“ ...” Dayofweek“ ...” ...＆lt; decimal_literal＆gt; ...＆lt; integer_literal＆gt; ...“ - ” ...“ true” ...“ false” ...“ date” ...“ Timeofday” ...“ DateTime” ...“ Timestamp” ... ...＆lt; quoted_id＆gt; ...“ min” ...“ max” ...“ avg” ...“ count” ...“ sum” ...“ no_values” ...“ no_format” ...“ ...”是“ .. 。带有“ ...”包含“ ...”开始“ ...”结尾“ ...”匹配“ ...”喜欢“ ...”现在“ ...”日期：“ ...” ...“季度” ...“下部” ...“ upper” ...“ dayofweek” ...“ todate” ...
我尝试通过“删除”，并且该功能效果很好，我已经查看了column和它与所有其他列相同。
我最近才开始学习如何使用查询功能，我不确定我在做什么错
When I am trying to use create this function. =QUERY(XXXXXXXXXX!$A$1:$CJ,"select BL,BM,BN,BK,BP,BQ,BR,BO,BT,BU,BV,BS,BX,BY,BZ,BW,CB,CC,CD,CA,CF,CG,CH,CE
where A > date '2022-03-21'") I get the following error.
Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "by" "BY "" at line 1, column 47. Was expecting one of: "true" ... "false" ... "date" ... "timeofday" ... "datetime" ... "timestamp" ... "min" ... "max" ... "avg" ... "count" ... "sum" ... "no_values" ... "no_format" ... "is" ... "null" ... "year" ... "month" ... "day" ... "hour" ... "minute" ... "second" ... "millisecond" ... "with" ... "contains" ... "starts" ... "ends" ... "matches" ... "like" ... "now" ... "dateDiff" ... "quarter" ... "lower" ... "upper" ... "dayOfWeek" ... "toDate" ... ... <INTEGER_LITERAL> ... <DECIMAL_LITERAL> ... <STRING_LITERAL> ... <QUOTED_ID> ... "(" ... "-" ... "min" ... "max" ... "count" ... "avg" ... "sum" ... "year" ... "month" ... "day" ... "hour" ... "minute" ... "second" ... "millisecond" ... "now" ... "dateDiff" ... "lower" ... "upper" ... "quarter" ... "dayOfWeek" ... "toDate" ... "(" ... <STRING_LITERAL> ... <DECIMAL_LITERAL> ... <INTEGER_LITERAL> ... "-" ... "true" ... "false" ... "date" ... "timeofday" ... "datetime" ... "timestamp" ... ... <QUOTED_ID> ... "min" ... "max" ... "avg" ... "count" ... "sum" ... "no_values" ... "no_format" ... "is" ... "null" ... "year" ... "month" ... "day" ... "hour" ... "minute" ... "second" ... "millisecond" ... "with" ... "contains" ... "starts" ... "ends" ... "matches" ... "like" ... "now" ... "dateDiff" ... "quarter" ... "lower" ... "upper" ... "dayOfWeek" ... "toDate" ...
I have tried removing "BY" and the function works perfectly, I have looked at the format for column BY and its the same as all the other columns.
I have recently just started learning how to use the query function and I am not sure what I am doing wrong
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
使用列的反向报价：
use backquotes for BY column: