Nonsequenced Temporal Query - Analytics Database - Teradata Vantage

Temporal Table Support

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
eud1628112402879.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
fif1472244754791
lifecycle
latest
Product Category
Teradata Vantage™

A nonsequenced query is a SELECT statement that treats temporal columns of temporal tables as if they were nontemporal columns. It does not place any special semantics on temporal columns. It considers all states simultaneously.

A NONSEQUENCED VALIDTIME query can optionally include a PA. In this case, the query produces a valid-time temporal table, where the valid time of the result set rows is the PA specified in the query. If a NONSEQUENCED VALIDTIME query does not include a PA, the query produces a nontemporal table as a result set.

A NONSEQUENCED TRANSACTIONTIME query cannot include a PA, and always produces a nontemporal table as a result set.