To query a transaction-time table for the current rows, use the CURRENT TRANSACTIONTIME temporal qualifier in the SELECT statement. For example:
CURRENT TRANSACTIONTIME SELECT * FROM Policy_Types;
The result is a nontemporal result set. (The result set does not include the transaction-time column.)
Policy_Name Policy_Type -------------------- ----------- Premium Automobile AP Basic Homeowner HM Basic Automobile AU Premium Homeowner HP