Oracle SELECT COUNT problem

Thérèse Hanquet

Delphi Developer

Wed, 23 Apr 2003 03:00:00 GMT

Oracle SELECT COUNT problem

Hi Fabiano,

Just a guess - try

SELECT COUNT(YYY) FROM XXXX WHERE YYY = :YY GROUP BY YYY

Thrse

<supo..

Delphi Developer

Sat, 26 Apr 2003 03:00:00 GMT

I still get an error. Now i get the Oracle Error: Its not a GROUP BY
expression.

tks,

Fabiano

Thrse Hanquet escreveu na mensagem <3a040390_1@dnews>...

>Hi Fabiano,

>Just a guess - try

> SELECT COUNT(YYY) FROM XXXX WHERE YYY = :YY GROUP BY YYY

>Thrse