Re: What is wrong with the following query?

From: ZENARI Denis <zenari_at_ifrance.com>
Date: Wed, 16 Aug 2000 15:27:48 +0200
Message-ID: <8ne5la$mh3$1@reader1.fr.uu.net>

It works on my Oracle V7.3 core.
Try to put aliases ?? :

SELECT TRUNC(t173.timestamp,'DD') TR, COUNT(t173.id) CT FROM tableA t173
GROUP BY TR; In your example, you don't need the order by clause; Order by 1 asc is the default.

<ds3_99_at_my-deja.com> a écrit dans le message news: 8ncae5$ktu$1_at_nnrp1.deja.com...
> 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.
>
> - ds
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Aug 16 2000 - 08:27:48 CDT