第一个问题...
我一直在研究此站点,发现了一条应该对我有帮助的SQL ...但是我遇到了我无法解决的错误。查找以下SQL和错误:
SELECT field1,
Sum(IIf(status = "Accepted", 1, 0)) AS [field1_Accepted]
Sum(IIf(status = "Rejected", 1, 0)) AS [field1_Rejected]
Sum(IIf(status = "Cancelled", 1, 0)) AS [field1_Cancelled]
FROM tbl1
GROUP BY field1;
错误:SELECT语句包含一个保留字或一个拼写错误或丢失的参数名称,或者标点符号不正确。(错误3141)
我对这个查询的期望是:
field1/accepted/rejected/cancelled
a/1/2/3
b/2/3/5
c/2/3/4
字母应该是我的fld1名称,其他数字应该是对多少字段已接受,拒绝和取消状态的计数...
SELECT
语句中的表达式需要用逗号分隔。您在各列表达式之间缺少逗号:
SELECT field1,
Sum(IIf(status = "Accepted", 1, 0)) AS [field1_Accepted], -- <<== Here
Sum(IIf(status = "Rejected", 1, 0)) AS [field1_Rejected], -- <<== Here
Sum(IIf(status = "Cancelled", 1, 0)) AS [field1_Cancelled]
FROM tbl1
GROUP BY field1;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句