Re: Why I can not using alias in 11G
From: Havel Zhang <havel.zhang_at_gmail.com>
Date: Sun, 7 Feb 2010 23:12:03 -0800 (PST)
Message-ID: <bfe4f1b6-01ff-454f-9a21-a81f8c8e0f31_at_21g2000yqj.googlegroups.com>
On 2月8日, 下午2时22分, Serge Rielau <srie..._at_ca.ibm.com> wrote:
> That's odd.. the query looks fine by me.
> Assuming that the issue is the GROUP BY clause then it is correct NOT to
> specify the column aliases here because they are used for the output of
> the SELECT list. GROUP BY is processed before SELECT.
> The GROUP BY cannot see e.g. "D".
> From an ANSI point of view I see nothing wrong with this query.
>
> --
> Serge Rielau
> SQL Architect DB2 for LUW
> IBM Toronto Lab
Date: Sun, 7 Feb 2010 23:12:03 -0800 (PST)
Message-ID: <bfe4f1b6-01ff-454f-9a21-a81f8c8e0f31_at_21g2000yqj.googlegroups.com>
On 2月8日, 下午2时22分, Serge Rielau <srie..._at_ca.ibm.com> wrote:
> That's odd.. the query looks fine by me.
> Assuming that the issue is the GROUP BY clause then it is correct NOT to
> specify the column aliases here because they are used for the output of
> the SELECT list. GROUP BY is processed before SELECT.
> The GROUP BY cannot see e.g. "D".
> From an ANSI point of view I see nothing wrong with this query.
>
> --
> Serge Rielau
> SQL Architect DB2 for LUW
> IBM Toronto Lab
> From an ANSI point of view I see nothing wrong with this query.
yes, the query work fine in 10g, but cause ora-918 in 11G.
Received on Mon Feb 08 2010 - 01:12:03 CST