LEAD and LAG Analytic Functions
Lead function in oracle LEAD Function in Oracle is a Analytic function which has the ability to compute an expression on the next rows (rows which are going to come after the current row) and return the value to the current row. The general syntax of LEAD is shown below: LEAD (<expr>, <offset>, <default>) OVER …
LEAD and LAG Analytic Functions Read More »
