Re: SQL count by time intervals

From: HansF <News.Hans_at_telus.net>
Date: Wed, 09 Nov 2005 22:11:08 GMT
Message-Id: <pan.2005.11.09.22.11.03.968660@telus.net>

On Wed, 09 Nov 2005 14:09:16 -0800, Schroeder wrote:

> srivenu,
>
> Thanks a bunch for offering a hand.
>
> It seems Oracle doesn't like column aliases in group clauses:
>
> "ORA-00933: invalid column name"
>
> This presents a different problem because of the case statement.
>
> Any suggestions?

Oracle version might be relevant.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting relies guarantees I won't respond. ***

Received on Wed Nov 09 2005 - 16:11:08 CST