如下hql关联语句,想实现group by 去重:
querySentenceBuffer.append("FROM ComPerformance p,ComPerformancesub s,ComPerformanceval v,ComOrguserinfo u ");
querySentenceBuffer.append(" group by p.comOrguser.useridNum");出现错误提示如下:
ORA-00937: not a single-group group function
querySentenceBuffer.append("FROM ComPerformance p,ComPerformancesub s,ComPerformanceval v,ComOrguserinfo u ");
querySentenceBuffer.append(" group by p.comOrguser.useridNum");出现错误提示如下:
ORA-00937: not a single-group group function
select a,b,c from table1 group by a; 这样是报错的,要这样才不报错:
select a,b,c from table1 group by a,b,c;
在mysql中select a,b,c from table1 group by a;这个就能运行,哎……
ORA-00979: not a GROUP BY expression