What is wrong with the following query?
From: <ds3_99_at_my-deja.com>
Date: Tue, 15 Aug 2000 20:50:21 GMT
Message-ID: <8ncae5$ktu$1_at_nnrp1.deja.com>
Date: Tue, 15 Aug 2000 20:50:21 GMT
Message-ID: <8ncae5$ktu$1_at_nnrp1.deja.com>
Hi,
What is wrong with the following query?
[Quoted] [Quoted] SELECT TRUNC(t173.timestamp,'DD'), COUNT(t173.id)
FROM tableA t173
[Quoted] [Quoted] GROUP BY TRUNC(t173.timestamp,'DD') ORDER BY 1 ASC;
I use Oracle 8.1.6.1.0/Solaris 2.6, and get the following error:
ORA-12801: error signaled in parallel query server P000 ORA-00979: not a GROUP BY expression
Is this a problem with the Oracle version? Is there a fix for this?
Thanks in advance for your inputs.
- ds
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Aug 15 2000 - 22:50:21 CEST