错误信息:不是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 收起