Tag Archives: lag function

LEAD and LAG : Oracle Analytic Functions

Last updated on August 18th, 2019 at 05:47 pmLead Function LEAD 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 (<analytic_clause>) <expr> is the expression to compute from the leading row. <offset> … Continue reading LEAD and LAG : Oracle Analytic Functions »