Re: sql help - group by with subselect

On Tue, 24 Apr 2001 20:46:10 GMT, "Dave Fowler" <d.fowler_at_smmj.com> wrote:
>Ed,
>If you put the subquery in the group by it will work. You can't have alias
>references in group by

I have been told that this GROUP BY restriction is lifted in 8.1.n, where n is approximately equal to 7. Haven't verified if the person who told me that was thinking of the same restriction I was.

John

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/