UC知道错误信息：不是Group by 的表达式
来源：百度知道 编辑：UC知道 时间：2024/09/21 12:30:30
写成insert into bzrpcxt_pm select bzrxm as xingming ,count(bzrxm) as xiangshu,sum(fs) as zongfen,sum(fs)/count(bzrxm) from bzrpcxt_cc group by bzrxm order by 1,2正常
但改成多select一个列xn的时候，即
insert into bzrpcxt_pm select bzrxm as xingming ,count(bzrxm) as xiangshu,sum(fs) as zongfen,sum(fs)/count(bzrxm)，xn from bzrpcxt_cc group by bzrxm order by 1,2（其中列改好了，类型也一样）
报错：不是Group by 的表达式
但改成多select一个列xn的时候，即
insert into bzrpcxt_pm select bzrxm as xingming ,count(bzrxm) as xiangshu,sum(fs) as zongfen,sum(fs)/count(bzrxm)，xn from bzrpcxt_cc group by bzrxm order by 1,2（其中列改好了，类型也一样）
报错：不是Group by 的表达式
这个XN 或者要在GROUP BY 后面的分组列表中，
或者在要加上聚合函数，如MAX(XN),MIN(SN)等
即，
这样：
insert into bzrpcxt_pm select bzrxm as xingming ,count(bzrxm) as xiangshu,sum(fs) as zongfen,sum(fs)/count(bzrxm),xn=MAX(XN) from bzrpcxt_cc group by bzrxm order by 1,2
或者：
insert into bzrpcxt_pm select bzrxm as xingming ,count(bzrxm) as xiangshu,sum(fs) as zongfen,sum(fs)/count(bzrxm),xn=MAX(XN) from bzrpcxt_cc group by bzrxm,XN order by 1,2