Re: Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 05 Mar 2006 15:15:28 +0100
Message-ID: <ehsl02hcr8ko7vm9pckll2ro3pbgqteqvh@4ax.com>

On 4 Mar 2006 12:14:03 -0800, "Jining Han" <jining.han_at_gmail.com> wrote:

>Yes, a view (inline or not) is OK, but I just want to be able to
>explain.
>
>Thanks
>JH

It is quite simple, yet it seems you just dont *want* to understand it:
aliases are not allowed in GROUP BY clause. That's how the SQL syntax is defined and that's all there is it to it.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Mar 05 2006 - 08:15:28 CST

This message: [ Message body ]
Next message: lindseke: "Database link from 9i to 10g"
Previous message: jonathan.conway_at_gmail.com: "Best way to learn Oracle?"
In reply to: Jining Han: "Re: Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY?"
Next in thread: Jining Han: "Re: Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY?"
Reply: Jining Han: "Re: Alias for a CASE WHEN expression in a SELECT cannot be used in GROUP BY?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US