17.05 - Valid UNION Operations - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

Besides simple queries, UNION can be used within the following operations:

  • Derived tables
    You cannot use the HASH BY or LOCAL ORDER BY clauses in derived tables with set operators.
  • Subqueries
  • INSERT … SELECT statements
  • Non-recursive CREATE VIEW statements

UNION ALL is the only valid set operator in a WITH RECURSIVE clause or CREATE RECURSIVE VIEW statement that defines a recursive query.