ORA-00979: nota GROUP By expesion
先看sql语句,放在MySQL中没问题select w.name name, w.code code,count(*)from CJG_YWZH.VEHICLE vleft join CJG_WARN1.dm_drv_zt won v.zt=w.codegroup by nameoracle分组时不能用别名,查询的字段有多少个,分组种类就必须有多少个那这样子呢select w.name name, w.code code,count(*)from CJG_YWZH.VEHICL
原创
2020-05-25 14:11:45 ·
212 阅读 ·
2 评论