注册

不是 GROUP BY 表达式

一孤舟 2023/12/12 585 2 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:linux
【CPU】:
【问题描述】*:
select "A"."TEACHING_CLASS_ID" AS "TEACHING_CLASS_ID","A"."TASK_ID" AS "TASK_ID","A"."TEACHING_CLASS_NAME" AS "TEACHING_CLASS_NAME","A"."TEACHING_CLASS_TYPE" AS "TEACHING_CLASS_TYPE","A"."STUDY_NATURE" AS "STUDY_NATURE","A"."GRADE_ID" AS "GRADE_ID","A"."MAJOR_ID" AS "MAJOR_ID","A"."CLASS_NUM" AS "CLASS_NUM","A"."IS_ENABLE" AS "IS_ENABLE","A"."TEACHING_PLAN_ID" AS "TEACHING_PLAN_ID","B"."COURSE_ID" AS "COURSE_ID","B"."COURSE_CODE" AS "COURSE_CODE","B"."COURSE_NAME" AS "COURSE_NAME","B"."COLLEGE_ID" AS "COLLEGE_ID","B"."COLLEGE_NAME" AS "COLLEGE_NAME","B"."COURSE_TYPE_ID" AS "COURSE_TYPE_ID","B"."COURSE_TYPE" AS "COURSE_TYPE","B"."COURSE_NATURE" AS "COURSE_NATURE","B"."MAJOR_PROP" AS "MAJOR_PROP","B"."CREDIT" AS "CREDIT","B"."LECTURE_HOUR" AS "LECTURE_HOUR","B"."EXPERIMENTAL_HOUR" AS "EXPERIMENTAL_HOUR","B"."COMPUTER_HOUR" AS "COMPUTER_HOUR","B"."OTHER_HOUR" AS "OTHER_HOUR",count("C"."ID") AS "STUDENTNUMBER" from (("LG_CCAS52"."TEACHING_CLASS" "A" left join "LG_CCAS52"."COURSE" "B" on(("A"."COURSE_ID" = "B"."COURSE_ID"))) left join "LG_CCAS52"."TEACHING_CLASS_STUDENT" "C" on((("A"."TEACHING_CLASS_ID" = "C"."TEACHING_CLASS_ID") and ("C"."FLAG" = 1)))) where (("A"."FLAG" = 1) and ("A"."IS_ENABLE" = 1)) group by "A"."TEACHING_CLASS_ID"
报错:执行失败(语句1)
-4080: 第43 行附近出现错误:
不是 GROUP BY 表达式

回答 0
暂无回答
扫一扫
联系客服