OLAP Function comparison scripts

These scripts compare the outcome of OLAP LAG, LAST_VALUE and FIRST_VALUE functions depending on the parameters used and the existence of nulls. Modify the common table expression values to test your own variants.

AttachmentSize
rank_denserank_rownumber.sql664 bytes
lag_last_variants.sql895 bytes
first_last_variants.sql839 bytes
VDM Access: 
VDM Public