Which two options can be specified in order to access a system-period temporal table for a specific point in time guaran
Posted: Fri Aug 26, 2022 9:58 am
Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?
A. A period-specification placed in the FROM clause of a subselect.
B. A period-specification placed in the WHERE clause of a subselect
C. A SELECT statement predicate against the transaction start ID of the base table.
D. A predicate against the start and end columns of the base table placed in the WHERE clause of a subselect. E. A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a SELECT against the temporal table.
A. A period-specification placed in the FROM clause of a subselect.
B. A period-specification placed in the WHERE clause of a subselect
C. A SELECT statement predicate against the transaction start ID of the base table.
D. A predicate against the start and end columns of the base table placed in the WHERE clause of a subselect. E. A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a SELECT against the temporal table.