有关group by报错,not a GOUP BY expression

来源：学生作业帮编辑：百度作业网作业帮分类：英语作业时间：2024/06/13 21:10:25

有关group by报错,not a GOUP BY expression
这条就会报错
select acmratt.brcode,sum(acmratt.tdccramt)from acmratt group by 1
但是,改成
select acmratt.brcode,sum(acmratt.tdccramt)from acmratt group by acmratt.brcode
就可以过…… 这是为什么,记得是可以用1来指代第一列的啊

用 1 是指在查询语句中第一个列这种用法限定在查询语句中列的概念 sum 做为聚合函数使用在分组中计算分组后的和是不可以使用 1 这种方式的

有关group by报错,not a GOUP BY expression ORCAL 查询报错：“not a single-group group function ” group by order by GROUP BY ROLLUP (A,B,C) HAVING A IS NOT NULL AND D NOT NULL是 GROUP BY ROLLUP (A,B,C) HAVING A IS NOT NULL AND D NOT access中expression是什么意思?诸如group by等表达的是什么呢?通俗易懂的解答 why not ( )English by working with a group .a .study b.to st I learn by studying on a group by working with a group是什么意思. group by group的意思 sql语句报错,选择列表中的列 'A.id' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中 group by(A+B)和group by A,B 的区别?