db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Cannot use column alias in HAVING clause
Date Fri, 10 Sep 2010 14:20:43 GMT
On 09/10/2010 02:48 AM, Chris Wilson wrote:
 > I'd like to be able to use a column alias (from the column list of the
 > SELECT statement) in the HAVING clause.
...
 > Derby clearly knows this, as using the expression instead of the alias
 > works:

After fairly extensive discussion (see this issue for a good overview:
https://issues.apache.org/jira/browse/DERBY-2457), the community decided,
I believe, that this was correct behavior according to the SQL standard.

thanks,

bryan

Mime
View raw message