mybatis根据sum的结果allpric排序报错

Question

SELECT name,tele,COUNT(pric) as countinfo,SUM(pric) as allpric from orderinfo,user
where user.uid=orderinfo.uid
GROUP BY user.tele
ORDER BY allpric DESC;

Answer 1

GROUP BY user.tele , user.name 或者SELECT name...中把name去掉。