语法错误string query1 = "SELECT 季度,COUNT(CASE WHEN 季度 = 'Q1' THEN 1 ELSE NULL END) AS Q1Count, COUNT(CASE WHEN 季度 = 'Q2' THEN 1 ELSE NULL END) AS Q2Count,COUNT(CASE WHEN 季度 = 'Q3' THEN 1 ELSE NULL END) AS Q3Count,COUNT(CASE WHEN 季度 = 'Q4' THEN 1 ELSE NULL END) AS Q4Count FROM FAIsum GROUP BY 季度 WHERE 审核年份 = @value1";

你的这条 SQL 查询语句有语法错误。在 GROUP BY 子句之后不能再使用 WHERE 子句。正确的写法应该是把 WHERE 子句移动到 FROM 子句中，使用 INNER JOIN 连接 FAIsum 表和其他表。以下是一个可能的修正版本：

SELECT
  季度,
  COUNT(CASE WHEN 季度 = 'Q1' THEN 1 ELSE NULL END) AS Q1Count,
  COUNT(CASE WHEN 季度 = 'Q2' THEN 1 ELSE NULL END) AS Q2Count,
  COUNT(CASE WHEN 季度 = 'Q3' THEN 1 ELSE NULL END) AS Q3Count,
  COUNT(CASE WHEN 季度 = 'Q4' THEN 1 ELSE NULL END) AS Q4Count
FROM
  FAIsum
  INNER JOIN 其他表 ON ...
WHERE
  审核年份 = @value1
GROUP BY
  季度

相关问题

语法错误 string query1 = "SELECT 季度,COUNT(CASE WHEN 季度 = 'Q1' THEN 1 ELSE NULL END) AS Q1Count, COUNT(CASE WHEN 季度 = 'Q2' THEN 1 ELSE NULL END) AS Q2Count,COUNT(CASE WHEN 季度 = 'Q3' THEN 1 ELSE NULL END) AS Q3Count,COUNT(CASE WHEN 季度 = 'Q4' THEN 1 ELSE NULL END) AS Q4Count ,审核年份 FROM FAIsum 审核年份 = @value1 GROUP BY 季度,审核年份";

这段代码中仍然存在语法错误，缺少了一个 WHERE 关键字，应该将"FROM FAIsum 审核年份"修改为"FROM FAIsum WHERE 审核年份"，即：

string query1 = "SELECT 季度,COUNT(CASE WHEN 季度 = 'Q1' THEN 1 ELSE NULL END) AS Q1Count, COUNT(CASE WHEN 季度 = 'Q2' THEN 1 ELSE NULL END) AS Q2Count,COUNT(CASE WHEN 季度 = 'Q3' THEN 1 ELSE NULL END) AS Q3Count,COUNT(CASE WHEN 季度 = 'Q4' THEN 1 ELSE NULL END) AS Q4Count ,审核年份 FROM FAIsum WHERE 审核年份 = @value1 GROUP BY 季度,审核年份";

又报错了string query1 = "SELECT 季度,COUNT(CASE WHEN 季度 = 'Q1' THEN 1 ELSE NULL END) AS Q1Count, COUNT(CASE WHEN 季度 = 'Q2' THEN 1 ELSE NULL END) AS Q2Count,COUNT(CASE WHEN 季度 = 'Q3' THEN 1 ELSE NULL END) AS Q3Count,COUNT(CASE WHEN 季度 = 'Q4' THEN 1 ELSE NULL END) AS Q4Count ,审核年份 FROM FAIsum 审核年份 = @value1 GROUP BY 季度";

这段代码中出现了一个语法错误，应该将最后的"GROUP BY 季度"修改为"GROUP BY 季度,审核年份"，即：

string query1 = "SELECT 季度,COUNT(CASE WHEN 季度 = 'Q1' THEN 1 ELSE NULL END) AS Q1Count, COUNT(CASE WHEN 季度 = 'Q2' THEN 1 ELSE NULL END) AS Q2Count,COUNT(CASE WHEN 季度 = 'Q3' THEN 1 ELSE NULL END) AS Q3Count,COUNT(CASE WHEN 季度 = 'Q4' THEN 1 ELSE NULL END) AS Q4Count ,审核年份 FROM FAIsum WHERE 审核年份 = @value1 GROUP BY 季度,审核年份";