Analytical functions – Lead and Lag
LAG: Using this function we can fetch the nth row before (Lag) the Current row without using self-join. It is useful when we need to compare the current row values with …
Analytical functions – Lead and Lag Read More