Re: Why I can not using alias in 11G

From: Serge Rielau <>
Date: Mon, 08 Feb 2010 01:22:51 -0500
Message-ID: <>

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
Received on Mon Feb 08 2010 - 00:22:51 CST

Original text of this message