select sum(price),count(username),cname from wyf group by username order by sum(price); 这个不能执行,报错了。在mysql 中是可以的。。 为什么在oracle中不行啊。 好久没有用它了。 在线等,谢谢各位高手了。
select sum(price),count(username),cname from wyf group by username,cname order by sum(price);
select sum(price),count(username),username from wyf group by username order by sum(price); 或 select sum(price),count(username),cname from wyf group by cname order by sum(price); group by 的内容要和select后的非聚合函数以外的字段相同
或
select sum(price),count(username),cname from wyf group by cname order by sum(price); group by 的内容要和select后的非聚合函数以外的字段相同