oracle group by 跟mysql group by 区别 Home » IDC云服务 » oracle group by 跟mysql group by 区别 oracle group by 和mysql group by 区别 oracle group by 和mysql group by 区别 oracle 对于group by 是严格的,所有要select出来的字段必须在group by后边出现,否则会报“ORA-00979 不是group by表达式” mysql 则不同。如果select出来的字段在group by 后面没有,则会随机取出来一个值