ORA-00979: nota GROUP By expesion

先看sql语句，放在MySQL中没问题

select w.name name, w.code code,count(*)
from CJG_YWZH.VEHICLE v
left join CJG_WARN1.dm_drv_zt w
on v.zt=w.code
group by name

oracle分组时不能用别名，查询的字段有多少个，分组种类就必须有多少个

那这样子呢

select w.name name, w.code code,count(*)
from CJG_YWZH.VEHICLE v
left join CJG_WARN1.dm_drv_zt w
on v.zt=w.code
group by name,code

也不行

正确写法

select w.name name, w.code code,count(*)
from CJG_YWZH.VEHICLE v
left join CJG_WARN1.dm_drv_zt w
on v.zt=w.code
group by w.name,w.code