query com group by e subselect
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;
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;
Briciosm
Curtidas 0
Respostas
Emerson Nascimento
02/10/2008
tente assim:
SELECT t1.C11 AS r1, t1.C12 AS r2, t2.C22 AS r3, COUNT(*) FROM table1 t1 LEFT JOIN tabela2 t2 on (t2.c21 = t1.c12) GROUP BY t1.C11, t1.C12, t2.C22 ORDER BY t1.C11, t1.C12, t2.C22
GOSTEI 0