SQL Elements
For supported SQL data types, statements, functions, and other elements, see the Analytics Engine SQL Language Guide.
On the SELECT statement, the following clauses and features are supported:
• WITH common_table_expression
• FIRST rowcount
• ALL, DISTINCT
• GROUP BY
• HAVING
• UNION
• UNION ALL
• INTERSECT
• EXCEPT
• ORDER BY
• Derived tables in FROM clause
• Subqueries (with limitations)
• Joins between Analytics Engine tables
• Joins between Ingres tables
• ANSI joins
Note: The CREATE INDEX statement is supported on Analytics Engine tables and can be issued only after the table has been created. One clustered index and multiple secondary indexes can be created.
Some SQL elements have restrictions when used in Analytics Engine. For more information, see
Incompatibilities with Ingres Database.
Last modified date: 09/11/2026