My Oracle Support Banner

HAVING clause cannot use SELECT item positions (23ai and later) (Doc ID 3070470.1)

Last updated on FEBRUARY 10, 2025

Applies to:

Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Oracle Database - Enterprise Edition - Version 23.5 and later
Information in this document applies to any platform.

Symptoms

Oracle Database 23ai introduces support for using column aliases or SELECT item positions in the GROUP BY clause. Additionally, column aliases are now supported in the HAVING clause. However, the HAVING clause still does not support the use of SELECT item positions.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.