group by race||','||gender||','||count(*)
might be better.
-Message d'origine-
De: Denham Eva [mailto:[EMAIL PROTECTED]]
Date: jeudi 22 août 2002 14:59
À: Multiple recipients of list ORACLE-L
Objet: Strange Data issue.
Hello Gurus,
I have a problem which I hope
Title: Strange Data issue.
Denham,
Your
"group by" does not match what you are selecting, thus the results are
wrong.
Change your query as follows:
select race||','||gender,count(*)
from
pers group by race||','||gender
Hope
this helps.
Tom Mercadante Oracle Certified
that one
char.
Regards,
Waleed
-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002
10:14 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Strange Data issue.
Denham,
Your
"group by" does not matc
, August 22, 2002 11:04
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Strange Data issue.
This
will not fix it.
Group by race,gender should return only one row for
each unique combination of both columns.
I
can not help on this except advising to check the ASCII