Re: Why I can not using alias in 11G
From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Mon, 08 Feb 2010 01:22:51 -0500
Message-ID: <7t9ou3F76nU1_at_mid.individual.net>
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.
Date: Mon, 08 Feb 2010 01:22:51 -0500
Message-ID: <7t9ou3F76nU1_at_mid.individual.net>
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 LabReceived on Mon Feb 08 2010 - 00:22:51 CST