Last Activation Example (LAST_VALUE)

Assume a series of account transactions. We want for every transaction of each account to display the latest activation for the transaction. We use the LAST_VALUE function. The DDL file defines the tables and loads some data used by the SQL script.

AttachmentSize
acct_actv.ddl1.2 KB
acct_actv.sql5.34 KB
VDM Access: