Posts by Rogério • 93 points
3 posts
-
1
votes1
answer493
viewsA: Oracle - Error returning "Name" + Count() - "not a GROUP BY Expression"
Fortunately with Motta’s comment I was able to solve my problem by putting the SELECT field in GROUP BY and adding a WHERE: select pessoa.nome, count(carro.idcarro) from pessoa, carro where…
-
0
votes1
answer493
viewsQ: Oracle - Error returning "Name" + Count() - "not a GROUP BY Expression"
Hello! I’m trying to return the names of people and the amount of cars each has according to the 2 tables below, but accuses the following error: ORA-00979: not a GROUP BY Expression 00979. 00000 -…
-
8
votes2
answers291
views