| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> What is wrong with the following query?
Hi,
What is wrong with the following query?
SELECT TRUNC(t173.timestamp,'DD'), COUNT(t173.id)
FROM tableA t173
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.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Aug 15 2000 - 15:50:21 CDT
 |
 |