17.10 - Nonsequenced Transaction-Time Queries - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

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

Nonsequenced transaction-time queries on transaction-time tables produce nontemporal tables as a result. Use the NONSEQUENCED TRANSACTIONTIME qualifier to query and compare across all transaction-time states simultaneously.

The nonsequenced query treats a transaction-time table as a table with a regular Period column with no special temporal semantics. References to the transaction-time column can appear anywhere in the query.

If the projection list specifies *, the transaction-time column is also projected.

If the query involves a bitemporal or valid-time table, refer to the following topics for additional information that applies to the valid-time dimension: