group by com subselect

Question

No oracle n�o tem geito de funcionar o group by...
Como resolver????
Obrigado!

SELECT C11 AS r1,
c12 AS r2,
(SELECT C22 FROM tabela2
WHERE c12 = c21) AS r3,
COUNT(*)
FROM table1
GROUP BY 1,2,3
ORDER BY 1,2,3;

Abonacin · Answer

Fala briciosm...Blz??Ent�o meu, o group by posicional (1,2,3) nao vai funcionar mesmo... Voc� vai ter que colocar o nome das colunas...Segundo, com subquery?? N�o acha melhor um join entre as tabelas??Olha s� uma sugest�o... Troque[code:1:96f75ca5c6]SELECT E.JOB AS CARGO,E.MGR AS GERENTE(SELECT D.DNAME FROM DEPT DWHERE D.DEPTNO = E.DEPTNO) AS DEPARTFROM EMP EGROUP BY E.JOB, E.MGR, (SUBQUERY...)ORDER BY 1,2,3;[/code:1:96f75ca5c6]por [code:1:96f75ca5c6]SELECT E.JOB, E.MGR, D.DNAME, COUNT(*)FROM   EMP E JOIN DEPT DON     (E.DEPTNO = D.DEPTNO )GROUP BY E.JOB, E.MGR, D.DNAME;[/code:1:96f75ca5c6]Talvez resolva seu problema...Qualquer coisa s� postar...Abra�o...