(lukaseder) A customer of my popular SQL training (which you should book!) has recently challenged me to optimise a hierarchical query that merges an archive log’s deltas in order to obtain a snapshot of some record at a given point in time.
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help