Analytics: 17 The LAG / LEAD clauses

Описание: blog: https://connor-mcdonald.com

Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at the lag and lead functions.

The sample problem we'll solve is: Collapsing repeated rows in an order history table to show only the days where the order changed status

Scripts: https://livesql.oracle.com/next/libra...